<?xml version="1.0" encoding="ascii"?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
          "DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
<head>
  <title>web2py.gluon.sqlhtml</title>
  <link rel="stylesheet" href="epydoc.css" type="text/css" />
  <script type="text/javascript" src="epydoc.js"></script>
</head>

<body bgcolor="white" text="black" link="blue" vlink="#204080"
      alink="#204080">
<!-- ==================== NAVIGATION BAR ==================== -->
<table class="navbar" border="0" width="100%" cellpadding="0"
       bgcolor="#a0c0ff" cellspacing="0">
  <tr valign="middle">
  <!-- Home link -->
      <th>&nbsp;&nbsp;&nbsp;<a
        href="web2py.gluon-module.html">Home</a>&nbsp;&nbsp;&nbsp;</th>

  <!-- Tree link -->
      <th>&nbsp;&nbsp;&nbsp;<a
        href="module-tree.html">Trees</a>&nbsp;&nbsp;&nbsp;</th>

  <!-- Index link -->
      <th>&nbsp;&nbsp;&nbsp;<a
        href="identifier-index.html">Indices</a>&nbsp;&nbsp;&nbsp;</th>

  <!-- Help link -->
      <th>&nbsp;&nbsp;&nbsp;<a
        href="help.html">Help</a>&nbsp;&nbsp;&nbsp;</th>

  <!-- Project homepage -->
      <th class="navbar" align="right" width="100%">
        <table border="0" cellpadding="0" cellspacing="0">
          <tr><th class="navbar" align="center"
            ><a class="navbar" target="_top" href="http://www.web2py.com">web2py Web Framework</a></th>
          </tr></table></th>
  </tr>
</table>
<table width="100%" cellpadding="0" cellspacing="0">
  <tr valign="top">
    <td width="100%">
      <span class="breadcrumbs">
        Package&nbsp;web2py ::
        <a href="web2py.gluon-module.html">Package&nbsp;gluon</a> ::
        Module&nbsp;sqlhtml
      </span>
    </td>
    <td>
      <table cellpadding="0" cellspacing="0">
        <!-- hide/show private -->
        <tr><td align="right"><span class="options">[<a href="javascript:void(0);" class="privatelink"
    onclick="toggle_private();">hide&nbsp;private</a>]</span></td></tr>
        <tr><td align="right"><span class="options"
            >[<a href="frames.html" target="_top">frames</a
            >]&nbsp;|&nbsp;<a href="web2py.gluon.sqlhtml-pysrc.html"
            target="_top">no&nbsp;frames</a>]</span></td></tr>
      </table>
    </td>
  </tr>
</table>
<h1 class="epydoc">Source Code for <a href="web2py.gluon.sqlhtml-module.html">Module web2py.gluon.sqlhtml</a></h1>
<pre class="py-src">
<a name="L1"></a><tt class="py-lineno">  1</tt>  <tt class="py-line"><tt class="py-comment">#!/usr/bin/python</tt> </tt>
<a name="L2"></a><tt class="py-lineno">  2</tt>  <tt class="py-line"><tt class="py-comment"></tt><tt class="py-comment"># -*- coding: utf-8 -*-</tt> </tt>
<a name="L3"></a><tt class="py-lineno">  3</tt>  <tt class="py-line"><tt class="py-comment"></tt> </tt>
<a name="L4"></a><tt class="py-lineno">  4</tt>  <tt class="py-line"><tt class="py-docstring">"""</tt> </tt>
<a name="L5"></a><tt class="py-lineno">  5</tt>  <tt class="py-line"><tt class="py-docstring">This file is part of web2py Web Framework (Copyrighted, 2007)</tt> </tt>
<a name="L6"></a><tt class="py-lineno">  6</tt>  <tt class="py-line"><tt class="py-docstring">Developed by Massimo Di Pierro &lt;mdipierro@cs.depaul.edu&gt;</tt> </tt>
<a name="L7"></a><tt class="py-lineno">  7</tt>  <tt class="py-line"><tt class="py-docstring">License: GPL v2</tt> </tt>
<a name="L8"></a><tt class="py-lineno">  8</tt>  <tt class="py-line"><tt class="py-docstring">"""</tt> </tt>
<a name="L9"></a><tt class="py-lineno">  9</tt>  <tt class="py-line"> </tt>
<a name="L10"></a><tt class="py-lineno"> 10</tt>  <tt class="py-line"><tt class="py-keyword">import</tt> <tt class="py-name">urllib</tt> </tt>
<a name="L11"></a><tt class="py-lineno"> 11</tt>  <tt class="py-line"><tt class="py-keyword">import</tt> <tt class="py-name">re</tt> </tt>
<a name="L12"></a><tt class="py-lineno"> 12</tt>  <tt class="py-line"><tt class="py-keyword">import</tt> <tt class="py-name">sys</tt> </tt>
<a name="L13"></a><tt class="py-lineno"> 13</tt>  <tt class="py-line"><tt class="py-keyword">import</tt> <tt class="py-name">os</tt> </tt>
<a name="L14"></a><tt class="py-lineno"> 14</tt>  <tt class="py-line"><tt class="py-keyword">import</tt> <tt class="py-name">uuid</tt> </tt>
<a name="L15"></a><tt class="py-lineno"> 15</tt>  <tt class="py-line"><tt class="py-keyword">import</tt> <tt class="py-name">shutil</tt> </tt>
<a name="L16"></a><tt class="py-lineno"> 16</tt>  <tt class="py-line"><tt class="py-keyword">import</tt> <tt class="py-name">cStringIO</tt> </tt>
<a name="L17"></a><tt class="py-lineno"> 17</tt>  <tt class="py-line"><tt class="py-keyword">import</tt> <tt class="py-name">copy</tt> </tt>
<a name="L18"></a><tt class="py-lineno"> 18</tt>  <tt class="py-line"><tt class="py-keyword">from</tt> <tt id="link-0" class="py-name" targets="Module web2py.gluon.html=web2py.gluon.html-module.html"><a title="web2py.gluon.html" class="py-name" href="#" onclick="return doclink('link-0', 'html', 'link-0');">html</a></tt> <tt class="py-keyword">import</tt> <tt class="py-op">*</tt> </tt>
<a name="L19"></a><tt class="py-lineno"> 19</tt>  <tt class="py-line"><tt class="py-keyword">from</tt> <tt id="link-1" class="py-name" targets="Function web2py.gluon.tools.validators()=web2py.gluon.tools-module.html#validators,Module web2py.gluon.validators=web2py.gluon.validators-module.html"><a title="web2py.gluon.tools.validators
web2py.gluon.validators" class="py-name" href="#" onclick="return doclink('link-1', 'validators', 'link-1');">validators</a></tt> <tt class="py-keyword">import</tt> <tt class="py-op">*</tt> </tt>
<a name="L20"></a><tt class="py-lineno"> 20</tt>  <tt class="py-line"><tt class="py-keyword">from</tt> <tt id="link-2" class="py-name" targets="Module web2py.gluon.sql=web2py.gluon.sql-module.html"><a title="web2py.gluon.sql" class="py-name" href="#" onclick="return doclink('link-2', 'sql', 'link-2');">sql</a></tt> <tt class="py-keyword">import</tt> <tt id="link-3" class="py-name" targets="Class web2py.gluon.sql.SQLStorage=web2py.gluon.sql.SQLStorage-class.html"><a title="web2py.gluon.sql.SQLStorage" class="py-name" href="#" onclick="return doclink('link-3', 'SQLStorage', 'link-3');">SQLStorage</a></tt><tt class="py-op">,</tt> <tt id="link-4" class="py-name" targets="Class web2py.gluon.sql.SQLDB=web2py.gluon.sql.SQLDB-class.html"><a title="web2py.gluon.sql.SQLDB" class="py-name" href="#" onclick="return doclink('link-4', 'SQLDB', 'link-4');">SQLDB</a></tt> </tt>
<a name="L21"></a><tt class="py-lineno"> 21</tt>  <tt class="py-line"><tt class="py-keyword">from</tt> <tt id="link-5" class="py-name" targets="Module web2py.gluon.storage=web2py.gluon.storage-module.html"><a title="web2py.gluon.storage" class="py-name" href="#" onclick="return doclink('link-5', 'storage', 'link-5');">storage</a></tt> <tt class="py-keyword">import</tt> <tt id="link-6" class="py-name" targets="Class web2py.gluon.storage.Storage=web2py.gluon.storage.Storage-class.html"><a title="web2py.gluon.storage.Storage" class="py-name" href="#" onclick="return doclink('link-6', 'Storage', 'link-6');">Storage</a></tt> </tt>
<a name="L22"></a><tt class="py-lineno"> 22</tt>  <tt class="py-line"> </tt>
<a name="L23"></a><tt class="py-lineno"> 23</tt>  <tt class="py-line"><tt id="link-7" class="py-name" targets="Variable web2py.gluon.sql.table_field=web2py.gluon.sql-module.html#table_field,Variable web2py.gluon.sqlhtml.table_field=web2py.gluon.sqlhtml-module.html#table_field,Variable web2py.gluon.tools.table_field=web2py.gluon.tools-module.html#table_field"><a title="web2py.gluon.sql.table_field
web2py.gluon.sqlhtml.table_field
web2py.gluon.tools.table_field" class="py-name" href="#" onclick="return doclink('link-7', 'table_field', 'link-7');">table_field</a></tt> <tt class="py-op">=</tt> <tt class="py-name">re</tt><tt class="py-op">.</tt><tt class="py-name">compile</tt><tt class="py-op">(</tt><tt class="py-string">'[\w_]+\.[\w_]+'</tt><tt class="py-op">)</tt> </tt>
<a name="L24"></a><tt class="py-lineno"> 24</tt>  <tt class="py-line"><tt id="link-8" class="py-name" targets="Variable web2py.gluon.sqlhtml.re_extension=web2py.gluon.sqlhtml-module.html#re_extension,Variable web2py.gluon.tools.re_extension=web2py.gluon.tools-module.html#re_extension"><a title="web2py.gluon.sqlhtml.re_extension
web2py.gluon.tools.re_extension" class="py-name" href="#" onclick="return doclink('link-8', 're_extension', 'link-8');">re_extension</a></tt> <tt class="py-op">=</tt> <tt class="py-name">re</tt><tt class="py-op">.</tt><tt class="py-name">compile</tt><tt class="py-op">(</tt><tt class="py-string">'\.\w+$'</tt><tt class="py-op">)</tt> </tt>
<a name="StringWidget"></a><div id="StringWidget-def"><a name="L25"></a><tt class="py-lineno"> 25</tt>  <tt class="py-line"> </tt>
<a name="L26"></a><tt class="py-lineno"> 26</tt>  <tt class="py-line"> </tt>
<a name="L27"></a><tt class="py-lineno"> 27</tt> <a class="py-toggle" href="#" id="StringWidget-toggle" onclick="return toggle('StringWidget');">-</a><tt class="py-line"><tt class="py-keyword">class</tt> <a class="py-def-name" href="web2py.gluon.sqlhtml.StringWidget-class.html">StringWidget</a><tt class="py-op">:</tt> </tt>
</div><div id="StringWidget-collapsed" style="display:none;" pad="+++" indent="++++"></div><div id="StringWidget-expanded"><a name="L28"></a><tt class="py-lineno"> 28</tt>  <tt class="py-line"> </tt>
<a name="L29"></a><tt class="py-lineno"> 29</tt>  <tt class="py-line">    <tt class="py-decorator">@</tt><tt class="py-decorator">staticmethod</tt> </tt>
<a name="StringWidget.widget"></a><div id="StringWidget.widget-def"><a name="L30"></a><tt class="py-lineno"> 30</tt> <a class="py-toggle" href="#" id="StringWidget.widget-toggle" onclick="return toggle('StringWidget.widget');">-</a><tt class="py-line">    <tt class="py-keyword">def</tt> <a class="py-def-name" href="web2py.gluon.sqlhtml.StringWidget-class.html#widget">widget</a><tt class="py-op">(</tt><tt class="py-param">field</tt><tt class="py-op">,</tt> <tt class="py-param">value</tt><tt class="py-op">)</tt><tt class="py-op">:</tt> </tt>
</div><div id="StringWidget.widget-collapsed" style="display:none;" pad="+++" indent="++++++++"></div><div id="StringWidget.widget-expanded"><a name="L31"></a><tt class="py-lineno"> 31</tt>  <tt class="py-line">        <tt class="py-keyword">if</tt> <tt class="py-name">value</tt> <tt class="py-op">==</tt> <tt class="py-name">None</tt><tt class="py-op">:</tt> </tt>
<a name="L32"></a><tt class="py-lineno"> 32</tt>  <tt class="py-line">            <tt class="py-name">value</tt> <tt class="py-op">=</tt> <tt class="py-string">''</tt> </tt>
<a name="L33"></a><tt class="py-lineno"> 33</tt>  <tt class="py-line">        <tt class="py-name">id</tt> <tt class="py-op">=</tt> <tt class="py-string">'%s_%s'</tt> <tt class="py-op">%</tt> <tt class="py-op">(</tt><tt class="py-name">field</tt><tt class="py-op">.</tt><tt class="py-name">_tablename</tt><tt class="py-op">,</tt> <tt class="py-name">field</tt><tt class="py-op">.</tt><tt class="py-name">name</tt><tt class="py-op">)</tt> </tt>
<a name="L34"></a><tt class="py-lineno"> 34</tt>  <tt class="py-line">        <tt class="py-keyword">return</tt> <tt id="link-9" class="py-name" targets="Class web2py.gluon.html.INPUT=web2py.gluon.html.INPUT-class.html"><a title="web2py.gluon.html.INPUT" class="py-name" href="#" onclick="return doclink('link-9', 'INPUT', 'link-9');">INPUT</a></tt><tt class="py-op">(</tt> </tt>
<a name="L35"></a><tt class="py-lineno"> 35</tt>  <tt class="py-line">            <tt class="py-name">_type</tt><tt class="py-op">=</tt><tt class="py-string">'text'</tt><tt class="py-op">,</tt> </tt>
<a name="L36"></a><tt class="py-lineno"> 36</tt>  <tt class="py-line">            <tt class="py-name">_id</tt><tt class="py-op">=</tt><tt class="py-name">id</tt><tt class="py-op">,</tt> </tt>
<a name="L37"></a><tt class="py-lineno"> 37</tt>  <tt class="py-line">            <tt class="py-name">_class</tt><tt class="py-op">=</tt><tt class="py-name">field</tt><tt class="py-op">.</tt><tt class="py-name">type</tt><tt class="py-op">,</tt> </tt>
<a name="L38"></a><tt class="py-lineno"> 38</tt>  <tt class="py-line">            <tt class="py-name">_name</tt><tt class="py-op">=</tt><tt class="py-name">field</tt><tt class="py-op">.</tt><tt class="py-name">name</tt><tt class="py-op">,</tt> </tt>
<a name="L39"></a><tt class="py-lineno"> 39</tt>  <tt class="py-line">            <tt class="py-name">value</tt><tt class="py-op">=</tt><tt class="py-name">str</tt><tt class="py-op">(</tt><tt class="py-name">value</tt><tt class="py-op">)</tt><tt class="py-op">,</tt> </tt>
<a name="L40"></a><tt class="py-lineno"> 40</tt>  <tt class="py-line">            <tt class="py-name">requires</tt><tt class="py-op">=</tt><tt class="py-name">field</tt><tt class="py-op">.</tt><tt class="py-name">requires</tt><tt class="py-op">,</tt> </tt>
<a name="L41"></a><tt class="py-lineno"> 41</tt>  <tt class="py-line">            <tt class="py-op">)</tt> </tt>
</div></div><a name="L42"></a><tt class="py-lineno"> 42</tt>  <tt class="py-line"> </tt>
<a name="IntegerWidget"></a><div id="IntegerWidget-def"><a name="L43"></a><tt class="py-lineno"> 43</tt>  <tt class="py-line"> </tt>
<a name="L44"></a><tt class="py-lineno"> 44</tt> <a class="py-toggle" href="#" id="IntegerWidget-toggle" onclick="return toggle('IntegerWidget');">-</a><tt class="py-line"><tt class="py-keyword">class</tt> <a class="py-def-name" href="web2py.gluon.sqlhtml.IntegerWidget-class.html">IntegerWidget</a><tt class="py-op">(</tt><tt class="py-base-class">StringWidget</tt><tt class="py-op">)</tt><tt class="py-op">:</tt> </tt>
</div><div id="IntegerWidget-collapsed" style="display:none;" pad="+++" indent="++++"></div><div id="IntegerWidget-expanded"><a name="L45"></a><tt class="py-lineno"> 45</tt>  <tt class="py-line"> </tt>
<a name="L46"></a><tt class="py-lineno"> 46</tt>  <tt class="py-line">    <tt class="py-keyword">pass</tt> </tt>
</div><a name="L47"></a><tt class="py-lineno"> 47</tt>  <tt class="py-line"> </tt>
<a name="DoubleWidget"></a><div id="DoubleWidget-def"><a name="L48"></a><tt class="py-lineno"> 48</tt>  <tt class="py-line"> </tt>
<a name="L49"></a><tt class="py-lineno"> 49</tt> <a class="py-toggle" href="#" id="DoubleWidget-toggle" onclick="return toggle('DoubleWidget');">-</a><tt class="py-line"><tt class="py-keyword">class</tt> <a class="py-def-name" href="web2py.gluon.sqlhtml.DoubleWidget-class.html">DoubleWidget</a><tt class="py-op">(</tt><tt class="py-base-class">StringWidget</tt><tt class="py-op">)</tt><tt class="py-op">:</tt> </tt>
</div><div id="DoubleWidget-collapsed" style="display:none;" pad="+++" indent="++++"></div><div id="DoubleWidget-expanded"><a name="L50"></a><tt class="py-lineno"> 50</tt>  <tt class="py-line"> </tt>
<a name="L51"></a><tt class="py-lineno"> 51</tt>  <tt class="py-line">    <tt class="py-keyword">pass</tt> </tt>
</div><a name="L52"></a><tt class="py-lineno"> 52</tt>  <tt class="py-line"> </tt>
<a name="TimeWidget"></a><div id="TimeWidget-def"><a name="L53"></a><tt class="py-lineno"> 53</tt>  <tt class="py-line"> </tt>
<a name="L54"></a><tt class="py-lineno"> 54</tt> <a class="py-toggle" href="#" id="TimeWidget-toggle" onclick="return toggle('TimeWidget');">-</a><tt class="py-line"><tt class="py-keyword">class</tt> <a class="py-def-name" href="web2py.gluon.sqlhtml.TimeWidget-class.html">TimeWidget</a><tt class="py-op">(</tt><tt class="py-base-class">StringWidget</tt><tt class="py-op">)</tt><tt class="py-op">:</tt> </tt>
</div><div id="TimeWidget-collapsed" style="display:none;" pad="+++" indent="++++"></div><div id="TimeWidget-expanded"><a name="L55"></a><tt class="py-lineno"> 55</tt>  <tt class="py-line"> </tt>
<a name="L56"></a><tt class="py-lineno"> 56</tt>  <tt class="py-line">    <tt class="py-keyword">pass</tt> </tt>
</div><a name="L57"></a><tt class="py-lineno"> 57</tt>  <tt class="py-line"> </tt>
<a name="DateWidget"></a><div id="DateWidget-def"><a name="L58"></a><tt class="py-lineno"> 58</tt>  <tt class="py-line"> </tt>
<a name="L59"></a><tt class="py-lineno"> 59</tt> <a class="py-toggle" href="#" id="DateWidget-toggle" onclick="return toggle('DateWidget');">-</a><tt class="py-line"><tt class="py-keyword">class</tt> <a class="py-def-name" href="web2py.gluon.sqlhtml.DateWidget-class.html">DateWidget</a><tt class="py-op">(</tt><tt class="py-base-class">StringWidget</tt><tt class="py-op">)</tt><tt class="py-op">:</tt> </tt>
</div><div id="DateWidget-collapsed" style="display:none;" pad="+++" indent="++++"></div><div id="DateWidget-expanded"><a name="L60"></a><tt class="py-lineno"> 60</tt>  <tt class="py-line"> </tt>
<a name="L61"></a><tt class="py-lineno"> 61</tt>  <tt class="py-line">    <tt class="py-keyword">pass</tt> </tt>
</div><a name="L62"></a><tt class="py-lineno"> 62</tt>  <tt class="py-line"> </tt>
<a name="DatetimeWidget"></a><div id="DatetimeWidget-def"><a name="L63"></a><tt class="py-lineno"> 63</tt>  <tt class="py-line"> </tt>
<a name="L64"></a><tt class="py-lineno"> 64</tt> <a class="py-toggle" href="#" id="DatetimeWidget-toggle" onclick="return toggle('DatetimeWidget');">-</a><tt class="py-line"><tt class="py-keyword">class</tt> <a class="py-def-name" href="web2py.gluon.sqlhtml.DatetimeWidget-class.html">DatetimeWidget</a><tt class="py-op">(</tt><tt class="py-base-class">StringWidget</tt><tt class="py-op">)</tt><tt class="py-op">:</tt> </tt>
</div><div id="DatetimeWidget-collapsed" style="display:none;" pad="+++" indent="++++"></div><div id="DatetimeWidget-expanded"><a name="L65"></a><tt class="py-lineno"> 65</tt>  <tt class="py-line"> </tt>
<a name="L66"></a><tt class="py-lineno"> 66</tt>  <tt class="py-line">    <tt class="py-keyword">pass</tt> </tt>
</div><a name="L67"></a><tt class="py-lineno"> 67</tt>  <tt class="py-line"> </tt>
<a name="TextWidget"></a><div id="TextWidget-def"><a name="L68"></a><tt class="py-lineno"> 68</tt>  <tt class="py-line"> </tt>
<a name="L69"></a><tt class="py-lineno"> 69</tt> <a class="py-toggle" href="#" id="TextWidget-toggle" onclick="return toggle('TextWidget');">-</a><tt class="py-line"><tt class="py-keyword">class</tt> <a class="py-def-name" href="web2py.gluon.sqlhtml.TextWidget-class.html">TextWidget</a><tt class="py-op">:</tt> </tt>
</div><div id="TextWidget-collapsed" style="display:none;" pad="+++" indent="++++"></div><div id="TextWidget-expanded"><a name="L70"></a><tt class="py-lineno"> 70</tt>  <tt class="py-line"> </tt>
<a name="L71"></a><tt class="py-lineno"> 71</tt>  <tt class="py-line">    <tt class="py-decorator">@</tt><tt class="py-decorator">staticmethod</tt> </tt>
<a name="TextWidget.widget"></a><div id="TextWidget.widget-def"><a name="L72"></a><tt class="py-lineno"> 72</tt> <a class="py-toggle" href="#" id="TextWidget.widget-toggle" onclick="return toggle('TextWidget.widget');">-</a><tt class="py-line">    <tt class="py-keyword">def</tt> <a class="py-def-name" href="web2py.gluon.sqlhtml.TextWidget-class.html#widget">widget</a><tt class="py-op">(</tt><tt class="py-param">field</tt><tt class="py-op">,</tt> <tt class="py-param">value</tt><tt class="py-op">)</tt><tt class="py-op">:</tt> </tt>
</div><div id="TextWidget.widget-collapsed" style="display:none;" pad="+++" indent="++++++++"></div><div id="TextWidget.widget-expanded"><a name="L73"></a><tt class="py-lineno"> 73</tt>  <tt class="py-line">        <tt class="py-name">id</tt> <tt class="py-op">=</tt> <tt class="py-string">'%s_%s'</tt> <tt class="py-op">%</tt> <tt class="py-op">(</tt><tt class="py-name">field</tt><tt class="py-op">.</tt><tt class="py-name">_tablename</tt><tt class="py-op">,</tt> <tt class="py-name">field</tt><tt class="py-op">.</tt><tt class="py-name">name</tt><tt class="py-op">)</tt> </tt>
<a name="L74"></a><tt class="py-lineno"> 74</tt>  <tt class="py-line">        <tt class="py-keyword">return</tt> <tt id="link-10" class="py-name" targets="Class web2py.gluon.html.TEXTAREA=web2py.gluon.html.TEXTAREA-class.html"><a title="web2py.gluon.html.TEXTAREA" class="py-name" href="#" onclick="return doclink('link-10', 'TEXTAREA', 'link-10');">TEXTAREA</a></tt><tt class="py-op">(</tt> </tt>
<a name="L75"></a><tt class="py-lineno"> 75</tt>  <tt class="py-line">            <tt class="py-name">_id</tt><tt class="py-op">=</tt><tt class="py-name">id</tt><tt class="py-op">,</tt> </tt>
<a name="L76"></a><tt class="py-lineno"> 76</tt>  <tt class="py-line">            <tt class="py-name">_class</tt><tt class="py-op">=</tt><tt class="py-name">field</tt><tt class="py-op">.</tt><tt class="py-name">type</tt><tt class="py-op">,</tt> </tt>
<a name="L77"></a><tt class="py-lineno"> 77</tt>  <tt class="py-line">            <tt class="py-name">_name</tt><tt class="py-op">=</tt><tt class="py-name">field</tt><tt class="py-op">.</tt><tt class="py-name">name</tt><tt class="py-op">,</tt> </tt>
<a name="L78"></a><tt class="py-lineno"> 78</tt>  <tt class="py-line">            <tt class="py-name">value</tt><tt class="py-op">=</tt><tt class="py-name">value</tt><tt class="py-op">,</tt> </tt>
<a name="L79"></a><tt class="py-lineno"> 79</tt>  <tt class="py-line">            <tt class="py-name">requires</tt><tt class="py-op">=</tt><tt class="py-name">field</tt><tt class="py-op">.</tt><tt class="py-name">requires</tt><tt class="py-op">,</tt> </tt>
<a name="L80"></a><tt class="py-lineno"> 80</tt>  <tt class="py-line">            <tt class="py-op">)</tt> </tt>
</div></div><a name="L81"></a><tt class="py-lineno"> 81</tt>  <tt class="py-line"> </tt>
<a name="BooleanWidget"></a><div id="BooleanWidget-def"><a name="L82"></a><tt class="py-lineno"> 82</tt>  <tt class="py-line"> </tt>
<a name="L83"></a><tt class="py-lineno"> 83</tt> <a class="py-toggle" href="#" id="BooleanWidget-toggle" onclick="return toggle('BooleanWidget');">-</a><tt class="py-line"><tt class="py-keyword">class</tt> <a class="py-def-name" href="web2py.gluon.sqlhtml.BooleanWidget-class.html">BooleanWidget</a><tt class="py-op">:</tt> </tt>
</div><div id="BooleanWidget-collapsed" style="display:none;" pad="+++" indent="++++"></div><div id="BooleanWidget-expanded"><a name="L84"></a><tt class="py-lineno"> 84</tt>  <tt class="py-line"> </tt>
<a name="L85"></a><tt class="py-lineno"> 85</tt>  <tt class="py-line">    <tt class="py-decorator">@</tt><tt class="py-decorator">staticmethod</tt> </tt>
<a name="BooleanWidget.widget"></a><div id="BooleanWidget.widget-def"><a name="L86"></a><tt class="py-lineno"> 86</tt> <a class="py-toggle" href="#" id="BooleanWidget.widget-toggle" onclick="return toggle('BooleanWidget.widget');">-</a><tt class="py-line">    <tt class="py-keyword">def</tt> <a class="py-def-name" href="web2py.gluon.sqlhtml.BooleanWidget-class.html#widget">widget</a><tt class="py-op">(</tt><tt class="py-param">field</tt><tt class="py-op">,</tt> <tt class="py-param">value</tt><tt class="py-op">)</tt><tt class="py-op">:</tt> </tt>
</div><div id="BooleanWidget.widget-collapsed" style="display:none;" pad="+++" indent="++++++++"></div><div id="BooleanWidget.widget-expanded"><a name="L87"></a><tt class="py-lineno"> 87</tt>  <tt class="py-line">        <tt class="py-name">id</tt> <tt class="py-op">=</tt> <tt class="py-string">'%s_%s'</tt> <tt class="py-op">%</tt> <tt class="py-op">(</tt><tt class="py-name">field</tt><tt class="py-op">.</tt><tt class="py-name">_tablename</tt><tt class="py-op">,</tt> <tt class="py-name">field</tt><tt class="py-op">.</tt><tt class="py-name">name</tt><tt class="py-op">)</tt> </tt>
<a name="L88"></a><tt class="py-lineno"> 88</tt>  <tt class="py-line">        <tt class="py-keyword">return</tt> <tt id="link-11" class="py-name"><a title="web2py.gluon.html.INPUT" class="py-name" href="#" onclick="return doclink('link-11', 'INPUT', 'link-9');">INPUT</a></tt><tt class="py-op">(</tt> </tt>
<a name="L89"></a><tt class="py-lineno"> 89</tt>  <tt class="py-line">            <tt class="py-name">_type</tt><tt class="py-op">=</tt><tt class="py-string">'checkbox'</tt><tt class="py-op">,</tt> </tt>
<a name="L90"></a><tt class="py-lineno"> 90</tt>  <tt class="py-line">            <tt class="py-name">_id</tt><tt class="py-op">=</tt><tt class="py-name">id</tt><tt class="py-op">,</tt> </tt>
<a name="L91"></a><tt class="py-lineno"> 91</tt>  <tt class="py-line">            <tt class="py-name">_class</tt><tt class="py-op">=</tt><tt class="py-name">field</tt><tt class="py-op">.</tt><tt class="py-name">type</tt><tt class="py-op">,</tt> </tt>
<a name="L92"></a><tt class="py-lineno"> 92</tt>  <tt class="py-line">            <tt class="py-name">_name</tt><tt class="py-op">=</tt><tt class="py-name">field</tt><tt class="py-op">.</tt><tt class="py-name">name</tt><tt class="py-op">,</tt> </tt>
<a name="L93"></a><tt class="py-lineno"> 93</tt>  <tt class="py-line">            <tt class="py-name">value</tt><tt class="py-op">=</tt><tt class="py-name">value</tt><tt class="py-op">,</tt> </tt>
<a name="L94"></a><tt class="py-lineno"> 94</tt>  <tt class="py-line">            <tt class="py-name">requires</tt><tt class="py-op">=</tt><tt class="py-name">field</tt><tt class="py-op">.</tt><tt class="py-name">requires</tt><tt class="py-op">,</tt> </tt>
<a name="L95"></a><tt class="py-lineno"> 95</tt>  <tt class="py-line">            <tt class="py-op">)</tt> </tt>
</div></div><a name="L96"></a><tt class="py-lineno"> 96</tt>  <tt class="py-line"> </tt>
<a name="OptionsWidget"></a><div id="OptionsWidget-def"><a name="L97"></a><tt class="py-lineno"> 97</tt>  <tt class="py-line"> </tt>
<a name="L98"></a><tt class="py-lineno"> 98</tt> <a class="py-toggle" href="#" id="OptionsWidget-toggle" onclick="return toggle('OptionsWidget');">-</a><tt class="py-line"><tt class="py-keyword">class</tt> <a class="py-def-name" href="web2py.gluon.sqlhtml.OptionsWidget-class.html">OptionsWidget</a><tt class="py-op">:</tt> </tt>
</div><div id="OptionsWidget-collapsed" style="display:none;" pad="+++" indent="++++"></div><div id="OptionsWidget-expanded"><a name="L99"></a><tt class="py-lineno"> 99</tt>  <tt class="py-line"> </tt>
<a name="L100"></a><tt class="py-lineno">100</tt>  <tt class="py-line">    <tt class="py-decorator">@</tt><tt class="py-decorator">staticmethod</tt> </tt>
<a name="OptionsWidget.has_options"></a><div id="OptionsWidget.has_options-def"><a name="L101"></a><tt class="py-lineno">101</tt> <a class="py-toggle" href="#" id="OptionsWidget.has_options-toggle" onclick="return toggle('OptionsWidget.has_options');">-</a><tt class="py-line">    <tt class="py-keyword">def</tt> <a class="py-def-name" href="web2py.gluon.sqlhtml.OptionsWidget-class.html#has_options">has_options</a><tt class="py-op">(</tt><tt class="py-param">field</tt><tt class="py-op">)</tt><tt class="py-op">:</tt> </tt>
</div><div id="OptionsWidget.has_options-collapsed" style="display:none;" pad="+++" indent="++++++++"></div><div id="OptionsWidget.has_options-expanded"><a name="L102"></a><tt class="py-lineno">102</tt>  <tt class="py-line">        <tt class="py-keyword">return</tt> <tt class="py-name">hasattr</tt><tt class="py-op">(</tt><tt class="py-name">field</tt><tt class="py-op">.</tt><tt class="py-name">requires</tt><tt class="py-op">,</tt> <tt class="py-string">'options'</tt><tt class="py-op">)</tt>\ </tt>
<a name="L103"></a><tt class="py-lineno">103</tt>  <tt class="py-line">             <tt class="py-keyword">or</tt> <tt class="py-name">isinstance</tt><tt class="py-op">(</tt><tt class="py-name">field</tt><tt class="py-op">.</tt><tt class="py-name">requires</tt><tt class="py-op">,</tt> <tt id="link-12" class="py-name" targets="Class web2py.gluon.validators.IS_NULL_OR=web2py.gluon.validators.IS_NULL_OR-class.html"><a title="web2py.gluon.validators.IS_NULL_OR" class="py-name" href="#" onclick="return doclink('link-12', 'IS_NULL_OR', 'link-12');">IS_NULL_OR</a></tt><tt class="py-op">)</tt>\ </tt>
<a name="L104"></a><tt class="py-lineno">104</tt>  <tt class="py-line">             <tt class="py-keyword">and</tt> <tt class="py-name">hasattr</tt><tt class="py-op">(</tt><tt class="py-name">field</tt><tt class="py-op">.</tt><tt class="py-name">requires</tt><tt class="py-op">.</tt><tt class="py-name">other</tt><tt class="py-op">,</tt> <tt class="py-string">'options'</tt><tt class="py-op">)</tt> </tt>
</div><a name="L105"></a><tt class="py-lineno">105</tt>  <tt class="py-line"> </tt>
<a name="L106"></a><tt class="py-lineno">106</tt>  <tt class="py-line">    <tt class="py-decorator">@</tt><tt class="py-decorator">staticmethod</tt> </tt>
<a name="OptionsWidget.widget"></a><div id="OptionsWidget.widget-def"><a name="L107"></a><tt class="py-lineno">107</tt> <a class="py-toggle" href="#" id="OptionsWidget.widget-toggle" onclick="return toggle('OptionsWidget.widget');">-</a><tt class="py-line">    <tt class="py-keyword">def</tt> <a class="py-def-name" href="web2py.gluon.sqlhtml.OptionsWidget-class.html#widget">widget</a><tt class="py-op">(</tt><tt class="py-param">field</tt><tt class="py-op">,</tt> <tt class="py-param">value</tt><tt class="py-op">)</tt><tt class="py-op">:</tt> </tt>
</div><div id="OptionsWidget.widget-collapsed" style="display:none;" pad="+++" indent="++++++++"></div><div id="OptionsWidget.widget-expanded"><a name="L108"></a><tt class="py-lineno">108</tt>  <tt class="py-line">        <tt class="py-name">id</tt> <tt class="py-op">=</tt> <tt class="py-string">'%s_%s'</tt> <tt class="py-op">%</tt> <tt class="py-op">(</tt><tt class="py-name">field</tt><tt class="py-op">.</tt><tt class="py-name">_tablename</tt><tt class="py-op">,</tt> <tt class="py-name">field</tt><tt class="py-op">.</tt><tt class="py-name">name</tt><tt class="py-op">)</tt> </tt>
<a name="L109"></a><tt class="py-lineno">109</tt>  <tt class="py-line">        <tt class="py-keyword">if</tt> <tt class="py-name">isinstance</tt><tt class="py-op">(</tt><tt class="py-name">field</tt><tt class="py-op">.</tt><tt class="py-name">requires</tt><tt class="py-op">,</tt> <tt id="link-13" class="py-name"><a title="web2py.gluon.validators.IS_NULL_OR" class="py-name" href="#" onclick="return doclink('link-13', 'IS_NULL_OR', 'link-12');">IS_NULL_OR</a></tt><tt class="py-op">)</tt>\ </tt>
<a name="L110"></a><tt class="py-lineno">110</tt>  <tt class="py-line">             <tt class="py-keyword">and</tt> <tt class="py-name">hasattr</tt><tt class="py-op">(</tt><tt class="py-name">field</tt><tt class="py-op">.</tt><tt class="py-name">requires</tt><tt class="py-op">.</tt><tt class="py-name">other</tt><tt class="py-op">,</tt> <tt class="py-string">'options'</tt><tt class="py-op">)</tt><tt class="py-op">:</tt> </tt>
<a name="L111"></a><tt class="py-lineno">111</tt>  <tt class="py-line">            <tt class="py-name">opts</tt> <tt class="py-op">=</tt> <tt class="py-op">[</tt><tt id="link-14" class="py-name" targets="Class web2py.gluon.html.OPTION=web2py.gluon.html.OPTION-class.html"><a title="web2py.gluon.html.OPTION" class="py-name" href="#" onclick="return doclink('link-14', 'OPTION', 'link-14');">OPTION</a></tt><tt class="py-op">(</tt><tt class="py-name">_value</tt><tt class="py-op">=</tt><tt class="py-string">''</tt><tt class="py-op">)</tt><tt class="py-op">]</tt> </tt>
<a name="L112"></a><tt class="py-lineno">112</tt>  <tt class="py-line">            <tt id="link-15" class="py-name" targets="Method web2py.gluon.validators.IS_IN_DB.options()=web2py.gluon.validators.IS_IN_DB-class.html#options,Method web2py.gluon.validators.IS_IN_SET.options()=web2py.gluon.validators.IS_IN_SET-class.html#options"><a title="web2py.gluon.validators.IS_IN_DB.options
web2py.gluon.validators.IS_IN_SET.options" class="py-name" href="#" onclick="return doclink('link-15', 'options', 'link-15');">options</a></tt> <tt class="py-op">=</tt> <tt class="py-name">field</tt><tt class="py-op">.</tt><tt class="py-name">requires</tt><tt class="py-op">.</tt><tt class="py-name">other</tt><tt class="py-op">.</tt><tt id="link-16" class="py-name"><a title="web2py.gluon.validators.IS_IN_DB.options
web2py.gluon.validators.IS_IN_SET.options" class="py-name" href="#" onclick="return doclink('link-16', 'options', 'link-15');">options</a></tt><tt class="py-op">(</tt><tt class="py-op">)</tt> </tt>
<a name="L113"></a><tt class="py-lineno">113</tt>  <tt class="py-line">        <tt class="py-keyword">elif</tt> <tt class="py-name">hasattr</tt><tt class="py-op">(</tt><tt class="py-name">field</tt><tt class="py-op">.</tt><tt class="py-name">requires</tt><tt class="py-op">,</tt> <tt class="py-string">'options'</tt><tt class="py-op">)</tt><tt class="py-op">:</tt> </tt>
<a name="L114"></a><tt class="py-lineno">114</tt>  <tt class="py-line">            <tt class="py-name">opts</tt> <tt class="py-op">=</tt> <tt class="py-op">[</tt><tt class="py-op">]</tt> </tt>
<a name="L115"></a><tt class="py-lineno">115</tt>  <tt class="py-line">            <tt id="link-17" class="py-name"><a title="web2py.gluon.validators.IS_IN_DB.options
web2py.gluon.validators.IS_IN_SET.options" class="py-name" href="#" onclick="return doclink('link-17', 'options', 'link-15');">options</a></tt> <tt class="py-op">=</tt> <tt class="py-name">field</tt><tt class="py-op">.</tt><tt class="py-name">requires</tt><tt class="py-op">.</tt><tt id="link-18" class="py-name"><a title="web2py.gluon.validators.IS_IN_DB.options
web2py.gluon.validators.IS_IN_SET.options" class="py-name" href="#" onclick="return doclink('link-18', 'options', 'link-15');">options</a></tt><tt class="py-op">(</tt><tt class="py-op">)</tt> </tt>
<a name="L116"></a><tt class="py-lineno">116</tt>  <tt class="py-line">        <tt class="py-keyword">else</tt><tt class="py-op">:</tt> </tt>
<a name="L117"></a><tt class="py-lineno">117</tt>  <tt class="py-line">            <tt class="py-keyword">raise</tt> <tt class="py-name">SyntaxError</tt><tt class="py-op">,</tt> <tt class="py-string">'widget cannot determine options'</tt> </tt>
<a name="L118"></a><tt class="py-lineno">118</tt>  <tt class="py-line">        <tt class="py-name">opts</tt> <tt class="py-op">+=</tt> <tt class="py-op">[</tt><tt id="link-19" class="py-name"><a title="web2py.gluon.html.OPTION" class="py-name" href="#" onclick="return doclink('link-19', 'OPTION', 'link-14');">OPTION</a></tt><tt class="py-op">(</tt><tt class="py-name">v</tt><tt class="py-op">,</tt> <tt class="py-name">_value</tt><tt class="py-op">=</tt><tt class="py-name">k</tt><tt class="py-op">)</tt> <tt class="py-keyword">for</tt> <tt class="py-op">(</tt><tt class="py-name">k</tt><tt class="py-op">,</tt> <tt class="py-name">v</tt><tt class="py-op">)</tt> <tt class="py-keyword">in</tt> <tt id="link-20" class="py-name"><a title="web2py.gluon.validators.IS_IN_DB.options
web2py.gluon.validators.IS_IN_SET.options" class="py-name" href="#" onclick="return doclink('link-20', 'options', 'link-15');">options</a></tt><tt class="py-op">]</tt> </tt>
<a name="L119"></a><tt class="py-lineno">119</tt>  <tt class="py-line">        <tt class="py-keyword">return</tt> <tt id="link-21" class="py-name" targets="Class web2py.gluon.html.SELECT=web2py.gluon.html.SELECT-class.html"><a title="web2py.gluon.html.SELECT" class="py-name" href="#" onclick="return doclink('link-21', 'SELECT', 'link-21');">SELECT</a></tt><tt class="py-op">(</tt><tt class="py-op">*</tt><tt class="py-name">opts</tt><tt class="py-op">,</tt> <tt class="py-op">**</tt><tt class="py-name">dict</tt><tt class="py-op">(</tt><tt class="py-name">_id</tt><tt class="py-op">=</tt><tt class="py-name">id</tt><tt class="py-op">,</tt> <tt class="py-name">_class</tt><tt class="py-op">=</tt><tt class="py-name">field</tt><tt class="py-op">.</tt><tt class="py-name">type</tt><tt class="py-op">,</tt> </tt>
<a name="L120"></a><tt class="py-lineno">120</tt>  <tt class="py-line">                      <tt class="py-name">_name</tt><tt class="py-op">=</tt><tt class="py-name">field</tt><tt class="py-op">.</tt><tt class="py-name">name</tt><tt class="py-op">,</tt> <tt class="py-name">value</tt><tt class="py-op">=</tt><tt class="py-name">value</tt><tt class="py-op">,</tt> </tt>
<a name="L121"></a><tt class="py-lineno">121</tt>  <tt class="py-line">                      <tt class="py-name">requires</tt><tt class="py-op">=</tt><tt class="py-name">field</tt><tt class="py-op">.</tt><tt class="py-name">requires</tt><tt class="py-op">)</tt><tt class="py-op">)</tt> </tt>
</div></div><a name="L122"></a><tt class="py-lineno">122</tt>  <tt class="py-line"> </tt>
<a name="MultipleOptionsWidget"></a><div id="MultipleOptionsWidget-def"><a name="L123"></a><tt class="py-lineno">123</tt>  <tt class="py-line"> </tt>
<a name="L124"></a><tt class="py-lineno">124</tt> <a class="py-toggle" href="#" id="MultipleOptionsWidget-toggle" onclick="return toggle('MultipleOptionsWidget');">-</a><tt class="py-line"><tt class="py-keyword">class</tt> <a class="py-def-name" href="web2py.gluon.sqlhtml.MultipleOptionsWidget-class.html">MultipleOptionsWidget</a><tt class="py-op">:</tt> </tt>
</div><div id="MultipleOptionsWidget-collapsed" style="display:none;" pad="+++" indent="++++"></div><div id="MultipleOptionsWidget-expanded"><a name="L125"></a><tt class="py-lineno">125</tt>  <tt class="py-line"> </tt>
<a name="L126"></a><tt class="py-lineno">126</tt>  <tt class="py-line">    <tt class="py-decorator">@</tt><tt class="py-decorator">staticmethod</tt> </tt>
<a name="MultipleOptionsWidget.widget"></a><div id="MultipleOptionsWidget.widget-def"><a name="L127"></a><tt class="py-lineno">127</tt> <a class="py-toggle" href="#" id="MultipleOptionsWidget.widget-toggle" onclick="return toggle('MultipleOptionsWidget.widget');">-</a><tt class="py-line">    <tt class="py-keyword">def</tt> <a class="py-def-name" href="web2py.gluon.sqlhtml.MultipleOptionsWidget-class.html#widget">widget</a><tt class="py-op">(</tt><tt class="py-param">field</tt><tt class="py-op">,</tt> <tt class="py-param">value</tt><tt class="py-op">,</tt> <tt class="py-param">size</tt><tt class="py-op">=</tt><tt class="py-number">5</tt><tt class="py-op">)</tt><tt class="py-op">:</tt> </tt>
</div><div id="MultipleOptionsWidget.widget-collapsed" style="display:none;" pad="+++" indent="++++++++"></div><div id="MultipleOptionsWidget.widget-expanded"><a name="L128"></a><tt class="py-lineno">128</tt>  <tt class="py-line">        <tt class="py-name">id</tt> <tt class="py-op">=</tt> <tt class="py-string">'%s_%s'</tt> <tt class="py-op">%</tt> <tt class="py-op">(</tt><tt class="py-name">field</tt><tt class="py-op">.</tt><tt class="py-name">_tablename</tt><tt class="py-op">,</tt> <tt class="py-name">field</tt><tt class="py-op">.</tt><tt class="py-name">name</tt><tt class="py-op">)</tt> </tt>
<a name="L129"></a><tt class="py-lineno">129</tt>  <tt class="py-line">        <tt class="py-keyword">if</tt> <tt class="py-name">isinstance</tt><tt class="py-op">(</tt><tt class="py-name">field</tt><tt class="py-op">.</tt><tt class="py-name">requires</tt><tt class="py-op">,</tt> <tt id="link-22" class="py-name"><a title="web2py.gluon.validators.IS_NULL_OR" class="py-name" href="#" onclick="return doclink('link-22', 'IS_NULL_OR', 'link-12');">IS_NULL_OR</a></tt><tt class="py-op">)</tt>\ </tt>
<a name="L130"></a><tt class="py-lineno">130</tt>  <tt class="py-line">             <tt class="py-keyword">and</tt> <tt class="py-name">hasattr</tt><tt class="py-op">(</tt><tt class="py-name">field</tt><tt class="py-op">.</tt><tt class="py-name">requires</tt><tt class="py-op">.</tt><tt class="py-name">other</tt><tt class="py-op">,</tt> <tt class="py-string">'options'</tt><tt class="py-op">)</tt><tt class="py-op">:</tt> </tt>
<a name="L131"></a><tt class="py-lineno">131</tt>  <tt class="py-line">            <tt class="py-name">opts</tt> <tt class="py-op">=</tt> <tt class="py-op">[</tt><tt id="link-23" class="py-name"><a title="web2py.gluon.html.OPTION" class="py-name" href="#" onclick="return doclink('link-23', 'OPTION', 'link-14');">OPTION</a></tt><tt class="py-op">(</tt><tt class="py-name">_value</tt><tt class="py-op">=</tt><tt class="py-string">''</tt><tt class="py-op">)</tt><tt class="py-op">]</tt> </tt>
<a name="L132"></a><tt class="py-lineno">132</tt>  <tt class="py-line">            <tt id="link-24" class="py-name"><a title="web2py.gluon.validators.IS_IN_DB.options
web2py.gluon.validators.IS_IN_SET.options" class="py-name" href="#" onclick="return doclink('link-24', 'options', 'link-15');">options</a></tt> <tt class="py-op">=</tt> <tt class="py-name">field</tt><tt class="py-op">.</tt><tt class="py-name">requires</tt><tt class="py-op">.</tt><tt class="py-name">other</tt><tt class="py-op">.</tt><tt id="link-25" class="py-name"><a title="web2py.gluon.validators.IS_IN_DB.options
web2py.gluon.validators.IS_IN_SET.options" class="py-name" href="#" onclick="return doclink('link-25', 'options', 'link-15');">options</a></tt><tt class="py-op">(</tt><tt class="py-op">)</tt> </tt>
<a name="L133"></a><tt class="py-lineno">133</tt>  <tt class="py-line">        <tt class="py-keyword">elif</tt> <tt class="py-name">hasattr</tt><tt class="py-op">(</tt><tt class="py-name">field</tt><tt class="py-op">.</tt><tt class="py-name">requires</tt><tt class="py-op">,</tt> <tt class="py-string">'options'</tt><tt class="py-op">)</tt><tt class="py-op">:</tt> </tt>
<a name="L134"></a><tt class="py-lineno">134</tt>  <tt class="py-line">            <tt class="py-name">opts</tt> <tt class="py-op">=</tt> <tt class="py-op">[</tt><tt class="py-op">]</tt> </tt>
<a name="L135"></a><tt class="py-lineno">135</tt>  <tt class="py-line">            <tt id="link-26" class="py-name"><a title="web2py.gluon.validators.IS_IN_DB.options
web2py.gluon.validators.IS_IN_SET.options" class="py-name" href="#" onclick="return doclink('link-26', 'options', 'link-15');">options</a></tt> <tt class="py-op">=</tt> <tt class="py-name">field</tt><tt class="py-op">.</tt><tt class="py-name">requires</tt><tt class="py-op">.</tt><tt id="link-27" class="py-name"><a title="web2py.gluon.validators.IS_IN_DB.options
web2py.gluon.validators.IS_IN_SET.options" class="py-name" href="#" onclick="return doclink('link-27', 'options', 'link-15');">options</a></tt><tt class="py-op">(</tt><tt class="py-op">)</tt> </tt>
<a name="L136"></a><tt class="py-lineno">136</tt>  <tt class="py-line">        <tt class="py-keyword">else</tt><tt class="py-op">:</tt> </tt>
<a name="L137"></a><tt class="py-lineno">137</tt>  <tt class="py-line">            <tt class="py-keyword">raise</tt> <tt class="py-name">SyntaxError</tt><tt class="py-op">,</tt> <tt class="py-string">'widget cannot determine options'</tt> </tt>
<a name="L138"></a><tt class="py-lineno">138</tt>  <tt class="py-line">        <tt class="py-name">opts</tt> <tt class="py-op">+=</tt> <tt class="py-op">[</tt><tt id="link-28" class="py-name"><a title="web2py.gluon.html.OPTION" class="py-name" href="#" onclick="return doclink('link-28', 'OPTION', 'link-14');">OPTION</a></tt><tt class="py-op">(</tt><tt class="py-name">v</tt><tt class="py-op">,</tt> <tt class="py-name">_value</tt><tt class="py-op">=</tt><tt class="py-name">k</tt><tt class="py-op">)</tt> <tt class="py-keyword">for</tt> <tt class="py-op">(</tt><tt class="py-name">k</tt><tt class="py-op">,</tt> <tt class="py-name">v</tt><tt class="py-op">)</tt> <tt class="py-keyword">in</tt> <tt id="link-29" class="py-name"><a title="web2py.gluon.validators.IS_IN_DB.options
web2py.gluon.validators.IS_IN_SET.options" class="py-name" href="#" onclick="return doclink('link-29', 'options', 'link-15');">options</a></tt><tt class="py-op">]</tt> </tt>
<a name="L139"></a><tt class="py-lineno">139</tt>  <tt class="py-line">        <tt class="py-keyword">return</tt> <tt id="link-30" class="py-name"><a title="web2py.gluon.html.SELECT" class="py-name" href="#" onclick="return doclink('link-30', 'SELECT', 'link-21');">SELECT</a></tt><tt class="py-op">(</tt><tt class="py-op">*</tt><tt class="py-name">opts</tt><tt class="py-op">,</tt> <tt class="py-op">**</tt><tt class="py-name">dict</tt><tt class="py-op">(</tt> </tt>
<a name="L140"></a><tt class="py-lineno">140</tt>  <tt class="py-line">            <tt class="py-name">_id</tt><tt class="py-op">=</tt><tt class="py-name">id</tt><tt class="py-op">,</tt> </tt>
<a name="L141"></a><tt class="py-lineno">141</tt>  <tt class="py-line">            <tt class="py-name">_class</tt><tt class="py-op">=</tt><tt class="py-name">field</tt><tt class="py-op">.</tt><tt class="py-name">type</tt><tt class="py-op">,</tt> </tt>
<a name="L142"></a><tt class="py-lineno">142</tt>  <tt class="py-line">            <tt class="py-name">_multiple</tt><tt class="py-op">=</tt><tt class="py-string">'multiple'</tt><tt class="py-op">,</tt> </tt>
<a name="L143"></a><tt class="py-lineno">143</tt>  <tt class="py-line">            <tt class="py-name">value</tt><tt class="py-op">=</tt><tt class="py-name">value</tt><tt class="py-op">,</tt> </tt>
<a name="L144"></a><tt class="py-lineno">144</tt>  <tt class="py-line">            <tt class="py-name">_name</tt><tt class="py-op">=</tt><tt class="py-name">field</tt><tt class="py-op">.</tt><tt class="py-name">name</tt><tt class="py-op">,</tt> </tt>
<a name="L145"></a><tt class="py-lineno">145</tt>  <tt class="py-line">            <tt class="py-name">requires</tt><tt class="py-op">=</tt><tt class="py-name">field</tt><tt class="py-op">.</tt><tt class="py-name">requires</tt><tt class="py-op">,</tt> </tt>
<a name="L146"></a><tt class="py-lineno">146</tt>  <tt class="py-line">            <tt class="py-name">_size</tt><tt class="py-op">=</tt><tt id="link-31" class="py-name" targets="Method web2py.gluon.sql.SQLField.min()=web2py.gluon.sql.SQLField-class.html#min"><a title="web2py.gluon.sql.SQLField.min" class="py-name" href="#" onclick="return doclink('link-31', 'min', 'link-31');">min</a></tt><tt class="py-op">(</tt><tt class="py-name">size</tt><tt class="py-op">,</tt> <tt class="py-name">len</tt><tt class="py-op">(</tt><tt class="py-name">opts</tt><tt class="py-op">)</tt><tt class="py-op">)</tt><tt class="py-op">,</tt> </tt>
<a name="L147"></a><tt class="py-lineno">147</tt>  <tt class="py-line">            <tt class="py-op">)</tt><tt class="py-op">)</tt> </tt>
</div></div><a name="L148"></a><tt class="py-lineno">148</tt>  <tt class="py-line"> </tt>
<a name="PasswordWidget"></a><div id="PasswordWidget-def"><a name="L149"></a><tt class="py-lineno">149</tt>  <tt class="py-line"> </tt>
<a name="L150"></a><tt class="py-lineno">150</tt> <a class="py-toggle" href="#" id="PasswordWidget-toggle" onclick="return toggle('PasswordWidget');">-</a><tt class="py-line"><tt class="py-keyword">class</tt> <a class="py-def-name" href="web2py.gluon.sqlhtml.PasswordWidget-class.html">PasswordWidget</a><tt class="py-op">:</tt> </tt>
</div><div id="PasswordWidget-collapsed" style="display:none;" pad="+++" indent="++++"></div><div id="PasswordWidget-expanded"><a name="L151"></a><tt class="py-lineno">151</tt>  <tt class="py-line"> </tt>
<a name="L152"></a><tt class="py-lineno">152</tt>  <tt class="py-line">    <tt class="py-decorator">@</tt><tt class="py-decorator">staticmethod</tt> </tt>
<a name="PasswordWidget.widget"></a><div id="PasswordWidget.widget-def"><a name="L153"></a><tt class="py-lineno">153</tt> <a class="py-toggle" href="#" id="PasswordWidget.widget-toggle" onclick="return toggle('PasswordWidget.widget');">-</a><tt class="py-line">    <tt class="py-keyword">def</tt> <a class="py-def-name" href="web2py.gluon.sqlhtml.PasswordWidget-class.html#widget">widget</a><tt class="py-op">(</tt><tt class="py-param">field</tt><tt class="py-op">,</tt> <tt class="py-param">value</tt><tt class="py-op">)</tt><tt class="py-op">:</tt> </tt>
</div><div id="PasswordWidget.widget-collapsed" style="display:none;" pad="+++" indent="++++++++"></div><div id="PasswordWidget.widget-expanded"><a name="L154"></a><tt class="py-lineno">154</tt>  <tt class="py-line">        <tt class="py-name">id</tt> <tt class="py-op">=</tt> <tt class="py-string">'%s_%s'</tt> <tt class="py-op">%</tt> <tt class="py-op">(</tt><tt class="py-name">field</tt><tt class="py-op">.</tt><tt class="py-name">_tablename</tt><tt class="py-op">,</tt> <tt class="py-name">field</tt><tt class="py-op">.</tt><tt class="py-name">name</tt><tt class="py-op">)</tt> </tt>
<a name="L155"></a><tt class="py-lineno">155</tt>  <tt class="py-line">        <tt class="py-keyword">if</tt> <tt class="py-name">value</tt><tt class="py-op">:</tt> </tt>
<a name="L156"></a><tt class="py-lineno">156</tt>  <tt class="py-line">            <tt class="py-name">value</tt> <tt class="py-op">=</tt> <tt class="py-string">'********'</tt> </tt>
<a name="L157"></a><tt class="py-lineno">157</tt>  <tt class="py-line">        <tt class="py-keyword">return</tt> <tt id="link-32" class="py-name"><a title="web2py.gluon.html.INPUT" class="py-name" href="#" onclick="return doclink('link-32', 'INPUT', 'link-9');">INPUT</a></tt><tt class="py-op">(</tt> </tt>
<a name="L158"></a><tt class="py-lineno">158</tt>  <tt class="py-line">            <tt class="py-name">_type</tt><tt class="py-op">=</tt><tt class="py-string">'password'</tt><tt class="py-op">,</tt> </tt>
<a name="L159"></a><tt class="py-lineno">159</tt>  <tt class="py-line">            <tt class="py-name">_id</tt><tt class="py-op">=</tt><tt class="py-name">id</tt><tt class="py-op">,</tt> </tt>
<a name="L160"></a><tt class="py-lineno">160</tt>  <tt class="py-line">            <tt class="py-name">_name</tt><tt class="py-op">=</tt><tt class="py-name">field</tt><tt class="py-op">.</tt><tt class="py-name">name</tt><tt class="py-op">,</tt> </tt>
<a name="L161"></a><tt class="py-lineno">161</tt>  <tt class="py-line">            <tt class="py-name">_value</tt><tt class="py-op">=</tt><tt class="py-name">value</tt><tt class="py-op">,</tt> </tt>
<a name="L162"></a><tt class="py-lineno">162</tt>  <tt class="py-line">            <tt class="py-name">_class</tt><tt class="py-op">=</tt><tt class="py-name">field</tt><tt class="py-op">.</tt><tt class="py-name">type</tt><tt class="py-op">,</tt> </tt>
<a name="L163"></a><tt class="py-lineno">163</tt>  <tt class="py-line">            <tt class="py-name">requires</tt><tt class="py-op">=</tt><tt class="py-name">field</tt><tt class="py-op">.</tt><tt class="py-name">requires</tt><tt class="py-op">,</tt> </tt>
<a name="L164"></a><tt class="py-lineno">164</tt>  <tt class="py-line">            <tt class="py-op">)</tt> </tt>
</div></div><a name="L165"></a><tt class="py-lineno">165</tt>  <tt class="py-line"> </tt>
<a name="UploadWidget"></a><div id="UploadWidget-def"><a name="L166"></a><tt class="py-lineno">166</tt>  <tt class="py-line"> </tt>
<a name="L167"></a><tt class="py-lineno">167</tt> <a class="py-toggle" href="#" id="UploadWidget-toggle" onclick="return toggle('UploadWidget');">-</a><tt class="py-line"><tt class="py-keyword">class</tt> <a class="py-def-name" href="web2py.gluon.sqlhtml.UploadWidget-class.html">UploadWidget</a><tt class="py-op">:</tt> </tt>
</div><div id="UploadWidget-collapsed" style="display:none;" pad="+++" indent="++++"></div><div id="UploadWidget-expanded"><a name="L168"></a><tt class="py-lineno">168</tt>  <tt class="py-line"> </tt>
<a name="L169"></a><tt class="py-lineno">169</tt>  <tt class="py-line">    <tt class="py-decorator">@</tt><tt class="py-decorator">staticmethod</tt> </tt>
<a name="UploadWidget.widget"></a><div id="UploadWidget.widget-def"><a name="L170"></a><tt class="py-lineno">170</tt> <a class="py-toggle" href="#" id="UploadWidget.widget-toggle" onclick="return toggle('UploadWidget.widget');">-</a><tt class="py-line">    <tt class="py-keyword">def</tt> <a class="py-def-name" href="web2py.gluon.sqlhtml.UploadWidget-class.html#widget">widget</a><tt class="py-op">(</tt><tt class="py-param">field</tt><tt class="py-op">,</tt> <tt class="py-param">value</tt><tt class="py-op">,</tt> <tt class="py-param">download_url</tt><tt class="py-op">=</tt><tt class="py-name">None</tt><tt class="py-op">)</tt><tt class="py-op">:</tt> </tt>
</div><div id="UploadWidget.widget-collapsed" style="display:none;" pad="+++" indent="++++++++"></div><div id="UploadWidget.widget-expanded"><a name="L171"></a><tt class="py-lineno">171</tt>  <tt class="py-line">        <tt class="py-name">id</tt> <tt class="py-op">=</tt> <tt class="py-string">'%s_%s'</tt> <tt class="py-op">%</tt> <tt class="py-op">(</tt><tt class="py-name">field</tt><tt class="py-op">.</tt><tt class="py-name">_tablename</tt><tt class="py-op">,</tt> <tt class="py-name">field</tt><tt class="py-op">.</tt><tt class="py-name">name</tt><tt class="py-op">)</tt> </tt>
<a name="L172"></a><tt class="py-lineno">172</tt>  <tt class="py-line">        <tt class="py-name">inp</tt> <tt class="py-op">=</tt> <tt id="link-33" class="py-name"><a title="web2py.gluon.html.INPUT" class="py-name" href="#" onclick="return doclink('link-33', 'INPUT', 'link-9');">INPUT</a></tt><tt class="py-op">(</tt><tt class="py-name">_type</tt><tt class="py-op">=</tt><tt class="py-string">'file'</tt><tt class="py-op">,</tt> <tt class="py-name">_id</tt><tt class="py-op">=</tt><tt class="py-name">id</tt><tt class="py-op">,</tt> <tt class="py-name">_class</tt><tt class="py-op">=</tt><tt class="py-name">field</tt><tt class="py-op">.</tt><tt class="py-name">type</tt><tt class="py-op">,</tt> </tt>
<a name="L173"></a><tt class="py-lineno">173</tt>  <tt class="py-line">                    <tt class="py-name">_name</tt><tt class="py-op">=</tt><tt class="py-name">field</tt><tt class="py-op">.</tt><tt class="py-name">name</tt><tt class="py-op">,</tt> <tt class="py-name">requires</tt><tt class="py-op">=</tt><tt class="py-name">field</tt><tt class="py-op">.</tt><tt class="py-name">requires</tt><tt class="py-op">)</tt> </tt>
<a name="L174"></a><tt class="py-lineno">174</tt>  <tt class="py-line">        <tt class="py-keyword">if</tt> <tt class="py-name">download_url</tt> <tt class="py-keyword">and</tt> <tt class="py-name">value</tt><tt class="py-op">:</tt> </tt>
<a name="L175"></a><tt class="py-lineno">175</tt>  <tt class="py-line">            <tt class="py-name">url</tt> <tt class="py-op">=</tt> <tt class="py-name">download_url</tt> <tt class="py-op">+</tt> <tt class="py-string">'/'</tt> <tt class="py-op">+</tt> <tt class="py-name">value</tt> </tt>
<a name="L176"></a><tt class="py-lineno">176</tt>  <tt class="py-line">            <tt class="py-op">(</tt><tt class="py-name">br</tt><tt class="py-op">,</tt> <tt class="py-name">image</tt><tt class="py-op">)</tt> <tt class="py-op">=</tt> <tt class="py-op">(</tt><tt class="py-string">''</tt><tt class="py-op">,</tt> <tt class="py-string">''</tt><tt class="py-op">)</tt> </tt>
<a name="L177"></a><tt class="py-lineno">177</tt>  <tt class="py-line">            <tt class="py-keyword">if</tt> <tt id="link-34" class="py-name" targets="Class web2py.gluon.sqlhtml.UploadWidget=web2py.gluon.sqlhtml.UploadWidget-class.html"><a title="web2py.gluon.sqlhtml.UploadWidget" class="py-name" href="#" onclick="return doclink('link-34', 'UploadWidget', 'link-34');">UploadWidget</a></tt><tt class="py-op">.</tt><tt id="link-35" class="py-name" targets="Static Method web2py.gluon.sqlhtml.UploadWidget.is_image()=web2py.gluon.sqlhtml.UploadWidget-class.html#is_image"><a title="web2py.gluon.sqlhtml.UploadWidget.is_image" class="py-name" href="#" onclick="return doclink('link-35', 'is_image', 'link-35');">is_image</a></tt><tt class="py-op">(</tt><tt class="py-name">value</tt><tt class="py-op">)</tt><tt class="py-op">:</tt> </tt>
<a name="L178"></a><tt class="py-lineno">178</tt>  <tt class="py-line">                <tt class="py-op">(</tt><tt class="py-name">br</tt><tt class="py-op">,</tt> <tt class="py-name">image</tt><tt class="py-op">)</tt> <tt class="py-op">=</tt> <tt class="py-op">(</tt><tt id="link-36" class="py-name" targets="Class web2py.gluon.html.BR=web2py.gluon.html.BR-class.html"><a title="web2py.gluon.html.BR" class="py-name" href="#" onclick="return doclink('link-36', 'BR', 'link-36');">BR</a></tt><tt class="py-op">(</tt><tt class="py-op">)</tt><tt class="py-op">,</tt> <tt id="link-37" class="py-name" targets="Class web2py.gluon.html.IMG=web2py.gluon.html.IMG-class.html"><a title="web2py.gluon.html.IMG" class="py-name" href="#" onclick="return doclink('link-37', 'IMG', 'link-37');">IMG</a></tt><tt class="py-op">(</tt><tt class="py-name">_src</tt><tt class="py-op">=</tt><tt class="py-name">url</tt><tt class="py-op">,</tt> <tt class="py-name">_width</tt><tt class="py-op">=</tt><tt class="py-string">'150px'</tt><tt class="py-op">)</tt><tt class="py-op">)</tt> </tt>
<a name="L179"></a><tt class="py-lineno">179</tt>  <tt class="py-line">            <tt class="py-name">inp</tt> <tt class="py-op">=</tt> <tt id="link-38" class="py-name" targets="Class web2py.gluon.html.DIV=web2py.gluon.html.DIV-class.html"><a title="web2py.gluon.html.DIV" class="py-name" href="#" onclick="return doclink('link-38', 'DIV', 'link-38');">DIV</a></tt><tt class="py-op">(</tt> </tt>
<a name="L180"></a><tt class="py-lineno">180</tt>  <tt class="py-line">                <tt class="py-name">inp</tt><tt class="py-op">,</tt> </tt>
<a name="L181"></a><tt class="py-lineno">181</tt>  <tt class="py-line">                <tt class="py-string">'['</tt><tt class="py-op">,</tt> </tt>
<a name="L182"></a><tt class="py-lineno">182</tt>  <tt class="py-line">                <tt id="link-39" class="py-name" targets="Class web2py.gluon.html.A=web2py.gluon.html.A-class.html"><a title="web2py.gluon.html.A" class="py-name" href="#" onclick="return doclink('link-39', 'A', 'link-39');">A</a></tt><tt class="py-op">(</tt><tt class="py-string">'file'</tt><tt class="py-op">,</tt> <tt class="py-name">_href</tt><tt class="py-op">=</tt><tt class="py-name">url</tt><tt class="py-op">)</tt><tt class="py-op">,</tt> </tt>
<a name="L183"></a><tt class="py-lineno">183</tt>  <tt class="py-line">                <tt class="py-string">'|'</tt><tt class="py-op">,</tt> </tt>
<a name="L184"></a><tt class="py-lineno">184</tt>  <tt class="py-line">                <tt id="link-40" class="py-name"><a title="web2py.gluon.html.INPUT" class="py-name" href="#" onclick="return doclink('link-40', 'INPUT', 'link-9');">INPUT</a></tt><tt class="py-op">(</tt><tt class="py-name">_type</tt><tt class="py-op">=</tt><tt class="py-string">'checkbox'</tt><tt class="py-op">,</tt> <tt class="py-name">_name</tt><tt class="py-op">=</tt><tt class="py-name">field</tt><tt class="py-op">.</tt><tt class="py-name">name</tt> <tt class="py-op">+</tt> <tt class="py-string">'__delete'</tt><tt class="py-op">)</tt><tt class="py-op">,</tt> </tt>
<a name="L185"></a><tt class="py-lineno">185</tt>  <tt class="py-line">                <tt class="py-string">'delete]'</tt><tt class="py-op">,</tt> </tt>
<a name="L186"></a><tt class="py-lineno">186</tt>  <tt class="py-line">                <tt class="py-name">br</tt><tt class="py-op">,</tt> </tt>
<a name="L187"></a><tt class="py-lineno">187</tt>  <tt class="py-line">                <tt class="py-name">image</tt><tt class="py-op">,</tt> </tt>
<a name="L188"></a><tt class="py-lineno">188</tt>  <tt class="py-line">                <tt class="py-op">)</tt> </tt>
<a name="L189"></a><tt class="py-lineno">189</tt>  <tt class="py-line">        <tt class="py-keyword">return</tt> <tt class="py-name">inp</tt> </tt>
</div><a name="L190"></a><tt class="py-lineno">190</tt>  <tt class="py-line"> </tt>
<a name="L191"></a><tt class="py-lineno">191</tt>  <tt class="py-line">    <tt class="py-decorator">@</tt><tt class="py-decorator">staticmethod</tt> </tt>
<a name="UploadWidget.represent"></a><div id="UploadWidget.represent-def"><a name="L192"></a><tt class="py-lineno">192</tt> <a class="py-toggle" href="#" id="UploadWidget.represent-toggle" onclick="return toggle('UploadWidget.represent');">-</a><tt class="py-line">    <tt class="py-keyword">def</tt> <a class="py-def-name" href="web2py.gluon.sqlhtml.UploadWidget-class.html#represent">represent</a><tt class="py-op">(</tt><tt class="py-param">field</tt><tt class="py-op">,</tt> <tt class="py-param">value</tt><tt class="py-op">,</tt> <tt class="py-param">download_url</tt><tt class="py-op">=</tt><tt class="py-name">None</tt><tt class="py-op">)</tt><tt class="py-op">:</tt> </tt>
</div><div id="UploadWidget.represent-collapsed" style="display:none;" pad="+++" indent="++++++++"></div><div id="UploadWidget.represent-expanded"><a name="L193"></a><tt class="py-lineno">193</tt>  <tt class="py-line">        <tt class="py-name">id</tt> <tt class="py-op">=</tt> <tt class="py-string">'%s_%s'</tt> <tt class="py-op">%</tt> <tt class="py-op">(</tt><tt class="py-name">field</tt><tt class="py-op">.</tt><tt class="py-name">_tablename</tt><tt class="py-op">,</tt> <tt class="py-name">field</tt><tt class="py-op">.</tt><tt class="py-name">name</tt><tt class="py-op">)</tt> </tt>
<a name="L194"></a><tt class="py-lineno">194</tt>  <tt class="py-line">        <tt class="py-name">inp</tt> <tt class="py-op">=</tt> <tt class="py-string">'file'</tt> </tt>
<a name="L195"></a><tt class="py-lineno">195</tt>  <tt class="py-line">        <tt class="py-keyword">if</tt> <tt class="py-name">download_url</tt> <tt class="py-keyword">and</tt> <tt class="py-name">value</tt><tt class="py-op">:</tt> </tt>
<a name="L196"></a><tt class="py-lineno">196</tt>  <tt class="py-line">            <tt class="py-name">url</tt> <tt class="py-op">=</tt> <tt class="py-name">download_url</tt> <tt class="py-op">+</tt> <tt class="py-string">'/'</tt> <tt class="py-op">+</tt> <tt class="py-name">value</tt> </tt>
<a name="L197"></a><tt class="py-lineno">197</tt>  <tt class="py-line">            <tt class="py-keyword">if</tt> <tt id="link-41" class="py-name"><a title="web2py.gluon.sqlhtml.UploadWidget" class="py-name" href="#" onclick="return doclink('link-41', 'UploadWidget', 'link-34');">UploadWidget</a></tt><tt class="py-op">.</tt><tt id="link-42" class="py-name"><a title="web2py.gluon.sqlhtml.UploadWidget.is_image" class="py-name" href="#" onclick="return doclink('link-42', 'is_image', 'link-35');">is_image</a></tt><tt class="py-op">(</tt><tt class="py-name">value</tt><tt class="py-op">)</tt><tt class="py-op">:</tt> </tt>
<a name="L198"></a><tt class="py-lineno">198</tt>  <tt class="py-line">                <tt class="py-keyword">return</tt> <tt id="link-43" class="py-name"><a title="web2py.gluon.html.A" class="py-name" href="#" onclick="return doclink('link-43', 'A', 'link-39');">A</a></tt><tt class="py-op">(</tt><tt id="link-44" class="py-name"><a title="web2py.gluon.html.IMG" class="py-name" href="#" onclick="return doclink('link-44', 'IMG', 'link-37');">IMG</a></tt><tt class="py-op">(</tt><tt class="py-name">_src</tt><tt class="py-op">=</tt><tt class="py-name">url</tt><tt class="py-op">,</tt> <tt class="py-name">_width</tt><tt class="py-op">=</tt><tt class="py-string">'150px'</tt><tt class="py-op">)</tt><tt class="py-op">,</tt> <tt class="py-name">_href</tt><tt class="py-op">=</tt><tt class="py-name">url</tt><tt class="py-op">)</tt> </tt>
<a name="L199"></a><tt class="py-lineno">199</tt>  <tt class="py-line">            <tt class="py-keyword">return</tt> <tt id="link-45" class="py-name"><a title="web2py.gluon.html.A" class="py-name" href="#" onclick="return doclink('link-45', 'A', 'link-39');">A</a></tt><tt class="py-op">(</tt><tt class="py-string">'file'</tt><tt class="py-op">,</tt> <tt class="py-name">_href</tt><tt class="py-op">=</tt><tt class="py-name">url</tt><tt class="py-op">)</tt> </tt>
<a name="L200"></a><tt class="py-lineno">200</tt>  <tt class="py-line">        <tt class="py-keyword">return</tt> <tt class="py-name">inp</tt> </tt>
</div><a name="L201"></a><tt class="py-lineno">201</tt>  <tt class="py-line"> </tt>
<a name="L202"></a><tt class="py-lineno">202</tt>  <tt class="py-line">    <tt class="py-decorator">@</tt><tt class="py-decorator">staticmethod</tt> </tt>
<a name="UploadWidget.is_image"></a><div id="UploadWidget.is_image-def"><a name="L203"></a><tt class="py-lineno">203</tt> <a class="py-toggle" href="#" id="UploadWidget.is_image-toggle" onclick="return toggle('UploadWidget.is_image');">-</a><tt class="py-line">    <tt class="py-keyword">def</tt> <a class="py-def-name" href="web2py.gluon.sqlhtml.UploadWidget-class.html#is_image">is_image</a><tt class="py-op">(</tt><tt class="py-param">value</tt><tt class="py-op">)</tt><tt class="py-op">:</tt> </tt>
</div><div id="UploadWidget.is_image-collapsed" style="display:none;" pad="+++" indent="++++++++"></div><div id="UploadWidget.is_image-expanded"><a name="L204"></a><tt class="py-lineno">204</tt>  <tt class="py-line">        <tt class="py-name">extension</tt> <tt class="py-op">=</tt> <tt class="py-name">value</tt><tt class="py-op">.</tt><tt class="py-name">split</tt><tt class="py-op">(</tt><tt class="py-string">'.'</tt><tt class="py-op">)</tt><tt class="py-op">[</tt><tt class="py-op">-</tt><tt class="py-number">1</tt><tt class="py-op">]</tt><tt class="py-op">.</tt><tt id="link-46" class="py-name" targets="Method web2py.gluon.sql.SQLField.lower()=web2py.gluon.sql.SQLField-class.html#lower"><a title="web2py.gluon.sql.SQLField.lower" class="py-name" href="#" onclick="return doclink('link-46', 'lower', 'link-46');">lower</a></tt><tt class="py-op">(</tt><tt class="py-op">)</tt> </tt>
<a name="L205"></a><tt class="py-lineno">205</tt>  <tt class="py-line">        <tt class="py-keyword">if</tt> <tt class="py-name">extension</tt> <tt class="py-keyword">in</tt> <tt class="py-op">[</tt><tt class="py-string">'gif'</tt><tt class="py-op">,</tt> <tt class="py-string">'png'</tt><tt class="py-op">,</tt> <tt class="py-string">'jpg'</tt><tt class="py-op">,</tt> <tt class="py-string">'jpeg'</tt><tt class="py-op">,</tt> <tt class="py-string">'bmp'</tt><tt class="py-op">]</tt><tt class="py-op">:</tt> </tt>
<a name="L206"></a><tt class="py-lineno">206</tt>  <tt class="py-line">            <tt class="py-keyword">return</tt> <tt class="py-name">True</tt> </tt>
<a name="L207"></a><tt class="py-lineno">207</tt>  <tt class="py-line">        <tt class="py-keyword">return</tt> <tt class="py-name">False</tt> </tt>
</div></div><a name="L208"></a><tt class="py-lineno">208</tt>  <tt class="py-line"> </tt>
<a name="SQLFORM"></a><div id="SQLFORM-def"><a name="L209"></a><tt class="py-lineno">209</tt>  <tt class="py-line"> </tt>
<a name="L210"></a><tt class="py-lineno">210</tt> <a class="py-toggle" href="#" id="SQLFORM-toggle" onclick="return toggle('SQLFORM');">-</a><tt class="py-line"><tt class="py-keyword">class</tt> <a class="py-def-name" href="web2py.gluon.sqlhtml.SQLFORM-class.html">SQLFORM</a><tt class="py-op">(</tt><tt class="py-base-class">FORM</tt><tt class="py-op">)</tt><tt class="py-op">:</tt> </tt>
</div><div id="SQLFORM-collapsed" style="display:none;" pad="+++" indent="++++"></div><div id="SQLFORM-expanded"><a name="L211"></a><tt class="py-lineno">211</tt>  <tt class="py-line"> </tt>
<a name="L212"></a><tt class="py-lineno">212</tt>  <tt class="py-line">    <tt class="py-docstring">"""</tt> </tt>
<a name="L213"></a><tt class="py-lineno">213</tt>  <tt class="py-line"><tt class="py-docstring">    SQLFORM is used to map a table (and a current record) into an HTML form</tt> </tt>
<a name="L214"></a><tt class="py-lineno">214</tt>  <tt class="py-line"><tt class="py-docstring">   </tt> </tt>
<a name="L215"></a><tt class="py-lineno">215</tt>  <tt class="py-line"><tt class="py-docstring">    given a SQLTable stored in db.table</tt> </tt>
<a name="L216"></a><tt class="py-lineno">216</tt>  <tt class="py-line"><tt class="py-docstring"></tt> </tt>
<a name="L217"></a><tt class="py-lineno">217</tt>  <tt class="py-line"><tt class="py-docstring">    SQLFORM(db.table) generates an insert form</tt> </tt>
<a name="L218"></a><tt class="py-lineno">218</tt>  <tt class="py-line"><tt class="py-docstring">    record=db(db.table.id==some_id).select()[0]</tt> </tt>
<a name="L219"></a><tt class="py-lineno">219</tt>  <tt class="py-line"><tt class="py-docstring">    SQLFORM(db.table,record) generates an update form</tt> </tt>
<a name="L220"></a><tt class="py-lineno">220</tt>  <tt class="py-line"><tt class="py-docstring">    SQLFORM(db.table,record,deletable=True) generates an update </tt> </tt>
<a name="L221"></a><tt class="py-lineno">221</tt>  <tt class="py-line"><tt class="py-docstring">                                            with a delete button</tt> </tt>
<a name="L222"></a><tt class="py-lineno">222</tt>  <tt class="py-line"><tt class="py-docstring">    if record is an int, record=db(db.table.id==record).select()[0]</tt> </tt>
<a name="L223"></a><tt class="py-lineno">223</tt>  <tt class="py-line"><tt class="py-docstring">    optional arguments:</tt> </tt>
<a name="L224"></a><tt class="py-lineno">224</tt>  <tt class="py-line"><tt class="py-docstring">    </tt> </tt>
<a name="L225"></a><tt class="py-lineno">225</tt>  <tt class="py-line"><tt class="py-docstring">    fields: a list of fields that should be placed in the form, default is all.</tt> </tt>
<a name="L226"></a><tt class="py-lineno">226</tt>  <tt class="py-line"><tt class="py-docstring">    labels: a dictionary with labels for each field. keys are field names.</tt> </tt>
<a name="L227"></a><tt class="py-lineno">227</tt>  <tt class="py-line"><tt class="py-docstring">    col3  : a dictionary with content for an optional third column </tt> </tt>
<a name="L228"></a><tt class="py-lineno">228</tt>  <tt class="py-line"><tt class="py-docstring">            (right of each field). keys are field names.</tt> </tt>
<a name="L229"></a><tt class="py-lineno">229</tt>  <tt class="py-line"><tt class="py-docstring">    linkto: the URL of a controller/function to access referencedby records</tt> </tt>
<a name="L230"></a><tt class="py-lineno">230</tt>  <tt class="py-line"><tt class="py-docstring">            see controller appadmin.py for examples</tt> </tt>
<a name="L231"></a><tt class="py-lineno">231</tt>  <tt class="py-line"><tt class="py-docstring">    upload: the URL of a controller/function to download an uploaded file</tt> </tt>
<a name="L232"></a><tt class="py-lineno">232</tt>  <tt class="py-line"><tt class="py-docstring">            see controller appadmin.py for examples</tt> </tt>
<a name="L233"></a><tt class="py-lineno">233</tt>  <tt class="py-line"><tt class="py-docstring">    any named optional attribute is passed to the &lt;form&gt; tag</tt> </tt>
<a name="L234"></a><tt class="py-lineno">234</tt>  <tt class="py-line"><tt class="py-docstring">            for example _class, _id, _style, _action,_method, etc.</tt> </tt>
<a name="L235"></a><tt class="py-lineno">235</tt>  <tt class="py-line"><tt class="py-docstring"></tt> </tt>
<a name="L236"></a><tt class="py-lineno">236</tt>  <tt class="py-line"><tt class="py-docstring">    """</tt> </tt>
<a name="L237"></a><tt class="py-lineno">237</tt>  <tt class="py-line"> </tt>
<a name="L238"></a><tt class="py-lineno">238</tt>  <tt class="py-line">    <tt class="py-comment"># usability improvements proposal by fpp - 4 May 2008 :</tt> </tt>
<a name="L239"></a><tt class="py-lineno">239</tt>  <tt class="py-line"><tt class="py-comment"></tt>    <tt class="py-comment"># - correct labels (for points to field id, not field name)</tt> </tt>
<a name="L240"></a><tt class="py-lineno">240</tt>  <tt class="py-line"><tt class="py-comment"></tt>    <tt class="py-comment"># - add label for delete checkbox</tt> </tt>
<a name="L241"></a><tt class="py-lineno">241</tt>  <tt class="py-line"><tt class="py-comment"></tt>    <tt class="py-comment"># - add translatable label for record ID</tt> </tt>
<a name="L242"></a><tt class="py-lineno">242</tt>  <tt class="py-line"><tt class="py-comment"></tt>    <tt class="py-comment"># - add third column to right of fields, populated from the col3 dict</tt> </tt>
<a name="L243"></a><tt class="py-lineno">243</tt>  <tt class="py-line"><tt class="py-comment"></tt> </tt>
<a name="L244"></a><tt class="py-lineno">244</tt>  <tt class="py-line">    <tt id="link-47" class="py-name" targets="Variable web2py.gluon.sqlhtml.SQLFORM.widgets=web2py.gluon.sqlhtml.SQLFORM-class.html#widgets"><a title="web2py.gluon.sqlhtml.SQLFORM.widgets" class="py-name" href="#" onclick="return doclink('link-47', 'widgets', 'link-47');">widgets</a></tt> <tt class="py-op">=</tt> <tt id="link-48" class="py-name"><a title="web2py.gluon.storage.Storage" class="py-name" href="#" onclick="return doclink('link-48', 'Storage', 'link-6');">Storage</a></tt><tt class="py-op">(</tt><tt class="py-name">dict</tt><tt class="py-op">(</tt> </tt>
<a name="L245"></a><tt class="py-lineno">245</tt>  <tt class="py-line">        <tt class="py-name">string</tt><tt class="py-op">=</tt><tt id="link-49" class="py-name" targets="Class web2py.gluon.sqlhtml.StringWidget=web2py.gluon.sqlhtml.StringWidget-class.html"><a title="web2py.gluon.sqlhtml.StringWidget" class="py-name" href="#" onclick="return doclink('link-49', 'StringWidget', 'link-49');">StringWidget</a></tt><tt class="py-op">,</tt> </tt>
<a name="L246"></a><tt class="py-lineno">246</tt>  <tt class="py-line">        <tt class="py-name">text</tt><tt class="py-op">=</tt><tt id="link-50" class="py-name" targets="Class web2py.gluon.sqlhtml.TextWidget=web2py.gluon.sqlhtml.TextWidget-class.html"><a title="web2py.gluon.sqlhtml.TextWidget" class="py-name" href="#" onclick="return doclink('link-50', 'TextWidget', 'link-50');">TextWidget</a></tt><tt class="py-op">,</tt> </tt>
<a name="L247"></a><tt class="py-lineno">247</tt>  <tt class="py-line">        <tt class="py-name">password</tt><tt class="py-op">=</tt><tt id="link-51" class="py-name" targets="Class web2py.gluon.sqlhtml.PasswordWidget=web2py.gluon.sqlhtml.PasswordWidget-class.html"><a title="web2py.gluon.sqlhtml.PasswordWidget" class="py-name" href="#" onclick="return doclink('link-51', 'PasswordWidget', 'link-51');">PasswordWidget</a></tt><tt class="py-op">,</tt> </tt>
<a name="L248"></a><tt class="py-lineno">248</tt>  <tt class="py-line">        <tt class="py-name">integer</tt><tt class="py-op">=</tt><tt id="link-52" class="py-name" targets="Class web2py.gluon.sqlhtml.IntegerWidget=web2py.gluon.sqlhtml.IntegerWidget-class.html"><a title="web2py.gluon.sqlhtml.IntegerWidget" class="py-name" href="#" onclick="return doclink('link-52', 'IntegerWidget', 'link-52');">IntegerWidget</a></tt><tt class="py-op">,</tt> </tt>
<a name="L249"></a><tt class="py-lineno">249</tt>  <tt class="py-line">        <tt class="py-name">double</tt><tt class="py-op">=</tt><tt id="link-53" class="py-name" targets="Class web2py.gluon.sqlhtml.DoubleWidget=web2py.gluon.sqlhtml.DoubleWidget-class.html"><a title="web2py.gluon.sqlhtml.DoubleWidget" class="py-name" href="#" onclick="return doclink('link-53', 'DoubleWidget', 'link-53');">DoubleWidget</a></tt><tt class="py-op">,</tt> </tt>
<a name="L250"></a><tt class="py-lineno">250</tt>  <tt class="py-line">        <tt class="py-name">time</tt><tt class="py-op">=</tt><tt id="link-54" class="py-name" targets="Class web2py.gluon.sqlhtml.TimeWidget=web2py.gluon.sqlhtml.TimeWidget-class.html"><a title="web2py.gluon.sqlhtml.TimeWidget" class="py-name" href="#" onclick="return doclink('link-54', 'TimeWidget', 'link-54');">TimeWidget</a></tt><tt class="py-op">,</tt> </tt>
<a name="L251"></a><tt class="py-lineno">251</tt>  <tt class="py-line">        <tt class="py-name">date</tt><tt class="py-op">=</tt><tt id="link-55" class="py-name" targets="Class web2py.gluon.sqlhtml.DateWidget=web2py.gluon.sqlhtml.DateWidget-class.html"><a title="web2py.gluon.sqlhtml.DateWidget" class="py-name" href="#" onclick="return doclink('link-55', 'DateWidget', 'link-55');">DateWidget</a></tt><tt class="py-op">,</tt> </tt>
<a name="L252"></a><tt class="py-lineno">252</tt>  <tt class="py-line">        <tt class="py-name">datetime</tt><tt class="py-op">=</tt><tt id="link-56" class="py-name" targets="Class web2py.gluon.sqlhtml.DatetimeWidget=web2py.gluon.sqlhtml.DatetimeWidget-class.html"><a title="web2py.gluon.sqlhtml.DatetimeWidget" class="py-name" href="#" onclick="return doclink('link-56', 'DatetimeWidget', 'link-56');">DatetimeWidget</a></tt><tt class="py-op">,</tt> </tt>
<a name="L253"></a><tt class="py-lineno">253</tt>  <tt class="py-line">        <tt class="py-name">upload</tt><tt class="py-op">=</tt><tt id="link-57" class="py-name"><a title="web2py.gluon.sqlhtml.UploadWidget" class="py-name" href="#" onclick="return doclink('link-57', 'UploadWidget', 'link-34');">UploadWidget</a></tt><tt class="py-op">,</tt> </tt>
<a name="L254"></a><tt class="py-lineno">254</tt>  <tt class="py-line">        <tt class="py-name">boolean</tt><tt class="py-op">=</tt><tt id="link-58" class="py-name" targets="Class web2py.gluon.sqlhtml.BooleanWidget=web2py.gluon.sqlhtml.BooleanWidget-class.html"><a title="web2py.gluon.sqlhtml.BooleanWidget" class="py-name" href="#" onclick="return doclink('link-58', 'BooleanWidget', 'link-58');">BooleanWidget</a></tt><tt class="py-op">,</tt> </tt>
<a name="L255"></a><tt class="py-lineno">255</tt>  <tt class="py-line">        <tt class="py-name">blob</tt><tt class="py-op">=</tt><tt class="py-name">None</tt><tt class="py-op">,</tt> </tt>
<a name="L256"></a><tt class="py-lineno">256</tt>  <tt class="py-line">        <tt id="link-59" class="py-name"><a title="web2py.gluon.validators.IS_IN_DB.options
web2py.gluon.validators.IS_IN_SET.options" class="py-name" href="#" onclick="return doclink('link-59', 'options', 'link-15');">options</a></tt><tt class="py-op">=</tt><tt id="link-60" class="py-name" targets="Class web2py.gluon.sqlhtml.OptionsWidget=web2py.gluon.sqlhtml.OptionsWidget-class.html"><a title="web2py.gluon.sqlhtml.OptionsWidget" class="py-name" href="#" onclick="return doclink('link-60', 'OptionsWidget', 'link-60');">OptionsWidget</a></tt><tt class="py-op">,</tt> </tt>
<a name="L257"></a><tt class="py-lineno">257</tt>  <tt class="py-line">        <tt class="py-name">multiple</tt><tt class="py-op">=</tt><tt id="link-61" class="py-name" targets="Class web2py.gluon.sqlhtml.MultipleOptionsWidget=web2py.gluon.sqlhtml.MultipleOptionsWidget-class.html"><a title="web2py.gluon.sqlhtml.MultipleOptionsWidget" class="py-name" href="#" onclick="return doclink('link-61', 'MultipleOptionsWidget', 'link-61');">MultipleOptionsWidget</a></tt><tt class="py-op">,</tt> </tt>
<a name="L258"></a><tt class="py-lineno">258</tt>  <tt class="py-line">        <tt class="py-op">)</tt><tt class="py-op">)</tt> </tt>
<a name="L259"></a><tt class="py-lineno">259</tt>  <tt class="py-line"> </tt>
<a name="SQLFORM.__init__"></a><div id="SQLFORM.__init__-def"><a name="L260"></a><tt class="py-lineno">260</tt> <a class="py-toggle" href="#" id="SQLFORM.__init__-toggle" onclick="return toggle('SQLFORM.__init__');">-</a><tt class="py-line">    <tt class="py-keyword">def</tt> <a class="py-def-name" href="web2py.gluon.sqlhtml.SQLFORM-class.html#__init__">__init__</a><tt class="py-op">(</tt> </tt>
<a name="L261"></a><tt class="py-lineno">261</tt>  <tt class="py-line">        <tt class="py-param">self</tt><tt class="py-op">,</tt> </tt>
<a name="L262"></a><tt class="py-lineno">262</tt>  <tt class="py-line">        <tt class="py-param">table</tt><tt class="py-op">,</tt> </tt>
<a name="L263"></a><tt class="py-lineno">263</tt>  <tt class="py-line">        <tt class="py-param">record</tt><tt class="py-op">=</tt><tt class="py-name">None</tt><tt class="py-op">,</tt> </tt>
<a name="L264"></a><tt class="py-lineno">264</tt>  <tt class="py-line">        <tt class="py-param">deletable</tt><tt class="py-op">=</tt><tt class="py-name">False</tt><tt class="py-op">,</tt> </tt>
<a name="L265"></a><tt class="py-lineno">265</tt>  <tt class="py-line">        <tt class="py-param">linkto</tt><tt class="py-op">=</tt><tt class="py-name">None</tt><tt class="py-op">,</tt> </tt>
<a name="L266"></a><tt class="py-lineno">266</tt>  <tt class="py-line">        <tt class="py-param">upload</tt><tt class="py-op">=</tt><tt class="py-name">None</tt><tt class="py-op">,</tt> </tt>
<a name="L267"></a><tt class="py-lineno">267</tt>  <tt class="py-line">        <tt class="py-param">fields</tt><tt class="py-op">=</tt><tt class="py-name">None</tt><tt class="py-op">,</tt> </tt>
<a name="L268"></a><tt class="py-lineno">268</tt>  <tt class="py-line">        <tt class="py-param">labels</tt><tt class="py-op">=</tt><tt class="py-name">None</tt><tt class="py-op">,</tt> </tt>
<a name="L269"></a><tt class="py-lineno">269</tt>  <tt class="py-line">        <tt class="py-param">col3</tt><tt class="py-op">=</tt><tt class="py-op">{</tt><tt class="py-op">}</tt><tt class="py-op">,</tt> </tt>
<a name="L270"></a><tt class="py-lineno">270</tt>  <tt class="py-line">        <tt class="py-param">submit_button</tt><tt class="py-op">=</tt><tt class="py-string">'Submit'</tt><tt class="py-op">,</tt> </tt>
<a name="L271"></a><tt class="py-lineno">271</tt>  <tt class="py-line">        <tt class="py-param">delete_label</tt><tt class="py-op">=</tt><tt class="py-string">'Check to delete:'</tt><tt class="py-op">,</tt> </tt>
<a name="L272"></a><tt class="py-lineno">272</tt>  <tt class="py-line">        <tt class="py-param">showid</tt><tt class="py-op">=</tt><tt class="py-name">True</tt><tt class="py-op">,</tt> </tt>
<a name="L273"></a><tt class="py-lineno">273</tt>  <tt class="py-line">        <tt class="py-param">readonly</tt><tt class="py-op">=</tt><tt class="py-name">False</tt><tt class="py-op">,</tt> </tt>
<a name="L274"></a><tt class="py-lineno">274</tt>  <tt class="py-line">        <tt class="py-param">comments</tt><tt class="py-op">=</tt><tt class="py-name">True</tt><tt class="py-op">,</tt> </tt>
<a name="L275"></a><tt class="py-lineno">275</tt>  <tt class="py-line">        <tt class="py-param">keepopts</tt><tt class="py-op">=</tt><tt class="py-op">[</tt><tt class="py-op">]</tt><tt class="py-op">,</tt> </tt>
<a name="L276"></a><tt class="py-lineno">276</tt>  <tt class="py-line">        <tt class="py-param">ignore_rw</tt><tt class="py-op">=</tt><tt class="py-name">False</tt><tt class="py-op">,</tt> </tt>
<a name="L277"></a><tt class="py-lineno">277</tt>  <tt class="py-line">        <tt class="py-op">**</tt><tt class="py-param">attributes</tt> </tt>
<a name="L278"></a><tt class="py-lineno">278</tt>  <tt class="py-line">        <tt class="py-op">)</tt><tt class="py-op">:</tt> </tt>
</div><div id="SQLFORM.__init__-collapsed" style="display:none;" pad="+++" indent="++++++++"></div><div id="SQLFORM.__init__-expanded"><a name="L279"></a><tt class="py-lineno">279</tt>  <tt class="py-line">        <tt class="py-docstring">"""</tt> </tt>
<a name="L280"></a><tt class="py-lineno">280</tt>  <tt class="py-line"><tt class="py-docstring">        SQLFORM(db.table,</tt> </tt>
<a name="L281"></a><tt class="py-lineno">281</tt>  <tt class="py-line"><tt class="py-docstring">               record=None,</tt> </tt>
<a name="L282"></a><tt class="py-lineno">282</tt>  <tt class="py-line"><tt class="py-docstring">               fields=['name'],</tt> </tt>
<a name="L283"></a><tt class="py-lineno">283</tt>  <tt class="py-line"><tt class="py-docstring">               labels={'name':'Your name'},</tt> </tt>
<a name="L284"></a><tt class="py-lineno">284</tt>  <tt class="py-line"><tt class="py-docstring">               linkto=URL(r=request,f='table/db/')</tt> </tt>
<a name="L285"></a><tt class="py-lineno">285</tt>  <tt class="py-line"><tt class="py-docstring">        """</tt> </tt>
<a name="L286"></a><tt class="py-lineno">286</tt>  <tt class="py-line"> </tt>
<a name="L287"></a><tt class="py-lineno">287</tt>  <tt class="py-line">        <tt class="py-name">nbsp</tt><tt class="py-op">=</tt><tt id="link-62" class="py-name" targets="Class web2py.gluon.html.XML=web2py.gluon.html.XML-class.html"><a title="web2py.gluon.html.XML" class="py-name" href="#" onclick="return doclink('link-62', 'XML', 'link-62');">XML</a></tt><tt class="py-op">(</tt><tt class="py-string">'&amp;nbsp;'</tt><tt class="py-op">)</tt> <tt class="py-comment"># Firefox2 does not display fields with blanks</tt> </tt>
<a name="L288"></a><tt class="py-lineno">288</tt>  <tt class="py-line">        <tt id="link-63" class="py-name" targets="Class web2py.gluon.html.FORM=web2py.gluon.html.FORM-class.html"><a title="web2py.gluon.html.FORM" class="py-name" href="#" onclick="return doclink('link-63', 'FORM', 'link-63');">FORM</a></tt><tt class="py-op">.</tt><tt id="link-64" class="py-name" targets="Method web2py.gluon.cache.Cache.__init__()=web2py.gluon.cache.Cache-class.html#__init__,Method web2py.gluon.cache.CacheInRam.__init__()=web2py.gluon.cache.CacheInRam-class.html#__init__,Method web2py.gluon.cache.CacheOnDisk.__init__()=web2py.gluon.cache.CacheOnDisk-class.html#__init__,Method web2py.gluon.globals.Request.__init__()=web2py.gluon.globals.Request-class.html#__init__,Method web2py.gluon.globals.Response.__init__()=web2py.gluon.globals.Response-class.html#__init__,Method web2py.gluon.highlight.Highlighter.__init__()=web2py.gluon.highlight.Highlighter-class.html#__init__,Method web2py.gluon.html.BEAUTIFY.__init__()=web2py.gluon.html.BEAUTIFY-class.html#__init__,Method web2py.gluon.html.DIV.__init__()=web2py.gluon.html.DIV-class.html#__init__,Method web2py.gluon.html.FORM.__init__()=web2py.gluon.html.FORM-class.html#__init__,Method web2py.gluon.html.XML.__init__()=web2py.gluon.html.XML-class.html#__init__,Method web2py.gluon.http.HTTP.__init__()=web2py.gluon.http.HTTP-class.html#__init__,Method web2py.gluon.languages.lazyT.__init__()=web2py.gluon.languages.lazyT-class.html#__init__,Method web2py.gluon.languages.translator.__init__()=web2py.gluon.languages.translator-class.html#__init__,Method web2py.gluon.main.HttpServer.__init__()=web2py.gluon.main.HttpServer-class.html#__init__,Method web2py.gluon.restricted.RestrictedError.__init__()=web2py.gluon.restricted.RestrictedError-class.html#__init__,Method web2py.gluon.sanitizer.XssCleaner.__init__()=web2py.gluon.sanitizer.XssCleaner-class.html#__init__,Method web2py.gluon.sql.SQLALL.__init__()=web2py.gluon.sql.SQLALL-class.html#__init__,Method web2py.gluon.sql.SQLDB.__init__()=web2py.gluon.sql.SQLDB-class.html#__init__,Method web2py.gluon.sql.SQLField.__init__()=web2py.gluon.sql.SQLField-class.html#__init__,Method web2py.gluon.sql.SQLJoin.__init__()=web2py.gluon.sql.SQLJoin-class.html#__init__,Method web2py.gluon.sql.SQLQuery.__init__()=web2py.gluon.sql.SQLQuery-class.html#__init__,Method web2py.gluon.sql.SQLRows.__init__()=web2py.gluon.sql.SQLRows-class.html#__init__,Method web2py.gluon.sql.SQLSet.__init__()=web2py.gluon.sql.SQLSet-class.html#__init__,Method web2py.gluon.sql.SQLTable.__init__()=web2py.gluon.sql.SQLTable-class.html#__init__,Method web2py.gluon.sql.SQLXorable.__init__()=web2py.gluon.sql.SQLXorable-class.html#__init__,Method web2py.gluon.sqlhtml.SQLFORM.__init__()=web2py.gluon.sqlhtml.SQLFORM-class.html#__init__,Method web2py.gluon.sqlhtml.SQLTABLE.__init__()=web2py.gluon.sqlhtml.SQLTABLE-class.html#__init__,Method web2py.gluon.tools.Auth.__init__()=web2py.gluon.tools.Auth-class.html#__init__,Method web2py.gluon.tools.Crud.__init__()=web2py.gluon.tools.Crud-class.html#__init__,Method web2py.gluon.tools.Mail.__init__()=web2py.gluon.tools.Mail-class.html#__init__,Method web2py.gluon.tools.Recaptcha.__init__()=web2py.gluon.tools.Recaptcha-class.html#__init__,Method web2py.gluon.tools.Service.__init__()=web2py.gluon.tools.Service-class.html#__init__,Method web2py.gluon.validators.CLEANUP.__init__()=web2py.gluon.validators.CLEANUP-class.html#__init__,Method web2py.gluon.validators.CRYPT.__init__()=web2py.gluon.validators.CRYPT-class.html#__init__,Method web2py.gluon.validators.IS_ALPHANUMERIC.__init__()=web2py.gluon.validators.IS_ALPHANUMERIC-class.html#__init__,Method web2py.gluon.validators.IS_DATE.__init__()=web2py.gluon.validators.IS_DATE-class.html#__init__,Method web2py.gluon.validators.IS_DATETIME.__init__()=web2py.gluon.validators.IS_DATETIME-class.html#__init__,Method web2py.gluon.validators.IS_EMAIL.__init__()=web2py.gluon.validators.IS_EMAIL-class.html#__init__,Method web2py.gluon.validators.IS_EXPR.__init__()=web2py.gluon.validators.IS_EXPR-class.html#__init__,Method web2py.gluon.validators.IS_FLOAT_IN_RANGE.__init__()=web2py.gluon.validators.IS_FLOAT_IN_RANGE-class.html#__init__,Method web2py.gluon.validators.IS_GENERIC_URL.__init__()=web2py.gluon.validators.IS_GENERIC_URL-class.html#__init__,Method web2py.gluon.validators.IS_HTTP_URL.__init__()=web2py.gluon.validators.IS_HTTP_URL-class.html#__init__,Method web2py.gluon.validators.IS_INT_IN_RANGE.__init__()=web2py.gluon.validators.IS_INT_IN_RANGE-class.html#__init__,Method web2py.gluon.validators.IS_IN_DB.__init__()=web2py.gluon.validators.IS_IN_DB-class.html#__init__,Method web2py.gluon.validators.IS_IN_SET.__init__()=web2py.gluon.validators.IS_IN_SET-class.html#__init__,Method web2py.gluon.validators.IS_IN_SUBSET.__init__()=web2py.gluon.validators.IS_IN_SUBSET-class.html#__init__,Method web2py.gluon.validators.IS_LENGTH.__init__()=web2py.gluon.validators.IS_LENGTH-class.html#__init__,Method web2py.gluon.validators.IS_LIST_OF.__init__()=web2py.gluon.validators.IS_LIST_OF-class.html#__init__,Method web2py.gluon.validators.IS_MATCH.__init__()=web2py.gluon.validators.IS_MATCH-class.html#__init__,Method web2py.gluon.validators.IS_NOT_EMPTY.__init__()=web2py.gluon.validators.IS_NOT_EMPTY-class.html#__init__,Method web2py.gluon.validators.IS_NOT_IN_DB.__init__()=web2py.gluon.validators.IS_NOT_IN_DB-class.html#__init__,Method web2py.gluon.validators.IS_NULL_OR.__init__()=web2py.gluon.validators.IS_NULL_OR-class.html#__init__,Method web2py.gluon.validators.IS_TIME.__init__()=web2py.gluon.validators.IS_TIME-class.html#__init__,Method web2py.gluon.validators.IS_URL.__init__()=web2py.gluon.validators.IS_URL-class.html#__init__,Method web2py.gluon.widget.IO.__init__()=web2py.gluon.widget.IO-class.html#__init__,Method web2py.gluon.widget.web2pyDialog.__init__()=web2py.gluon.widget.web2pyDialog-class.html#__init__,Method web2py.gluon.winservice.Service.__init__()=web2py.gluon.winservice.Service-class.html#__init__,Method web2py.gluon.wsgiserver.CherryPyWSGIServer.__init__()=web2py.gluon.wsgiserver.CherryPyWSGIServer-class.html#__init__,Method web2py.gluon.wsgiserver.HTTPConnection.__init__()=web2py.gluon.wsgiserver.HTTPConnection-class.html#__init__,Method web2py.gluon.wsgiserver.HTTPRequest.__init__()=web2py.gluon.wsgiserver.HTTPRequest-class.html#__init__,Method web2py.gluon.wsgiserver.SSLConnection.__init__()=web2py.gluon.wsgiserver.SSLConnection-class.html#__init__,Method web2py.gluon.wsgiserver.SizeCheckWrapper.__init__()=web2py.gluon.wsgiserver.SizeCheckWrapper-class.html#__init__,Method web2py.gluon.wsgiserver.ThreadPool.__init__()=web2py.gluon.wsgiserver.ThreadPool-class.html#__init__,Method web2py.gluon.wsgiserver.WSGIPathInfoDispatcher.__init__()=web2py.gluon.wsgiserver.WSGIPathInfoDispatcher-class.html#__init__,Method web2py.gluon.wsgiserver.WorkerThread.__init__()=web2py.gluon.wsgiserver.WorkerThread-class.html#__init__"><a title="web2py.gluon.cache.Cache.__init__
web2py.gluon.cache.CacheInRam.__init__
web2py.gluon.cache.CacheOnDisk.__init__
web2py.gluon.globals.Request.__init__
web2py.gluon.globals.Response.__init__
web2py.gluon.highlight.Highlighter.__init__
web2py.gluon.html.BEAUTIFY.__init__
web2py.gluon.html.DIV.__init__
web2py.gluon.html.FORM.__init__
web2py.gluon.html.XML.__init__
web2py.gluon.http.HTTP.__init__
web2py.gluon.languages.lazyT.__init__
web2py.gluon.languages.translator.__init__
web2py.gluon.main.HttpServer.__init__
web2py.gluon.restricted.RestrictedError.__init__
web2py.gluon.sanitizer.XssCleaner.__init__
web2py.gluon.sql.SQLALL.__init__
web2py.gluon.sql.SQLDB.__init__
web2py.gluon.sql.SQLField.__init__
web2py.gluon.sql.SQLJoin.__init__
web2py.gluon.sql.SQLQuery.__init__
web2py.gluon.sql.SQLRows.__init__
web2py.gluon.sql.SQLSet.__init__
web2py.gluon.sql.SQLTable.__init__
web2py.gluon.sql.SQLXorable.__init__
web2py.gluon.sqlhtml.SQLFORM.__init__
web2py.gluon.sqlhtml.SQLTABLE.__init__
web2py.gluon.tools.Auth.__init__
web2py.gluon.tools.Crud.__init__
web2py.gluon.tools.Mail.__init__
web2py.gluon.tools.Recaptcha.__init__
web2py.gluon.tools.Service.__init__
web2py.gluon.validators.CLEANUP.__init__
web2py.gluon.validators.CRYPT.__init__
web2py.gluon.validators.IS_ALPHANUMERIC.__init__
web2py.gluon.validators.IS_DATE.__init__
web2py.gluon.validators.IS_DATETIME.__init__
web2py.gluon.validators.IS_EMAIL.__init__
web2py.gluon.validators.IS_EXPR.__init__
web2py.gluon.validators.IS_FLOAT_IN_RANGE.__init__
web2py.gluon.validators.IS_GENERIC_URL.__init__
web2py.gluon.validators.IS_HTTP_URL.__init__
web2py.gluon.validators.IS_INT_IN_RANGE.__init__
web2py.gluon.validators.IS_IN_DB.__init__
web2py.gluon.validators.IS_IN_SET.__init__
web2py.gluon.validators.IS_IN_SUBSET.__init__
web2py.gluon.validators.IS_LENGTH.__init__
web2py.gluon.validators.IS_LIST_OF.__init__
web2py.gluon.validators.IS_MATCH.__init__
web2py.gluon.validators.IS_NOT_EMPTY.__init__
web2py.gluon.validators.IS_NOT_IN_DB.__init__
web2py.gluon.validators.IS_NULL_OR.__init__
web2py.gluon.validators.IS_TIME.__init__
web2py.gluon.validators.IS_URL.__init__
web2py.gluon.widget.IO.__init__
web2py.gluon.widget.web2pyDialog.__init__
web2py.gluon.winservice.Service.__init__
web2py.gluon.wsgiserver.CherryPyWSGIServer.__init__
web2py.gluon.wsgiserver.HTTPConnection.__init__
web2py.gluon.wsgiserver.HTTPRequest.__init__
web2py.gluon.wsgiserver.SSLConnection.__init__
web2py.gluon.wsgiserver.SizeCheckWrapper.__init__
web2py.gluon.wsgiserver.ThreadPool.__init__
web2py.gluon.wsgiserver.WSGIPathInfoDispatcher.__init__
web2py.gluon.wsgiserver.WorkerThread.__init__" class="py-name" href="#" onclick="return doclink('link-64', '__init__', 'link-64');">__init__</a></tt><tt class="py-op">(</tt><tt class="py-name">self</tt><tt class="py-op">,</tt> <tt class="py-op">*</tt><tt class="py-op">[</tt><tt class="py-op">]</tt><tt class="py-op">,</tt> <tt class="py-op">**</tt><tt class="py-name">attributes</tt><tt class="py-op">)</tt> </tt>
<a name="L289"></a><tt class="py-lineno">289</tt>  <tt class="py-line">        <tt class="py-name">ofields</tt><tt class="py-op">=</tt><tt class="py-name">fields</tt> </tt>
<a name="L290"></a><tt class="py-lineno">290</tt>  <tt class="py-line">        <tt class="py-keyword">if</tt> <tt class="py-name">fields</tt> <tt class="py-op">==</tt> <tt class="py-name">None</tt><tt class="py-op">:</tt> </tt>
<a name="L291"></a><tt class="py-lineno">291</tt>  <tt class="py-line">            <tt class="py-name">fields</tt> <tt class="py-op">=</tt> <tt class="py-op">[</tt><tt id="link-65" class="py-name" targets="Variable web2py.gluon.wsgiserver.SSLConnection.f=web2py.gluon.wsgiserver.SSLConnection-class.html#f"><a title="web2py.gluon.wsgiserver.SSLConnection.f" class="py-name" href="#" onclick="return doclink('link-65', 'f', 'link-65');">f</a></tt> <tt class="py-keyword">for</tt> <tt id="link-66" class="py-name"><a title="web2py.gluon.wsgiserver.SSLConnection.f" class="py-name" href="#" onclick="return doclink('link-66', 'f', 'link-65');">f</a></tt> <tt class="py-keyword">in</tt> <tt class="py-name">table</tt><tt class="py-op">.</tt><tt class="py-name">fields</tt> <tt class="py-keyword">if</tt> \ </tt>
<a name="L292"></a><tt class="py-lineno">292</tt>  <tt class="py-line">                      <tt class="py-name">ignore_rw</tt> <tt class="py-keyword">or</tt> <tt class="py-name">table</tt><tt class="py-op">[</tt><tt id="link-67" class="py-name"><a title="web2py.gluon.wsgiserver.SSLConnection.f" class="py-name" href="#" onclick="return doclink('link-67', 'f', 'link-65');">f</a></tt><tt class="py-op">]</tt><tt class="py-op">.</tt><tt class="py-name">writable</tt> <tt class="py-keyword">or</tt> <tt class="py-name">table</tt><tt class="py-op">[</tt><tt id="link-68" class="py-name"><a title="web2py.gluon.wsgiserver.SSLConnection.f" class="py-name" href="#" onclick="return doclink('link-68', 'f', 'link-65');">f</a></tt><tt class="py-op">]</tt><tt class="py-op">.</tt><tt class="py-name">readable</tt><tt class="py-op">]</tt> </tt>
<a name="L293"></a><tt class="py-lineno">293</tt>  <tt class="py-line">        <tt class="py-name">self</tt><tt class="py-op">.</tt><tt class="py-name">fields</tt> <tt class="py-op">=</tt> <tt class="py-name">fields</tt> </tt>
<a name="L294"></a><tt class="py-lineno">294</tt>  <tt class="py-line">        <tt class="py-keyword">if</tt> <tt class="py-keyword">not</tt> <tt class="py-string">'id'</tt> <tt class="py-keyword">in</tt> <tt class="py-name">self</tt><tt class="py-op">.</tt><tt class="py-name">fields</tt><tt class="py-op">:</tt> </tt>
<a name="L295"></a><tt class="py-lineno">295</tt>  <tt class="py-line">            <tt class="py-name">self</tt><tt class="py-op">.</tt><tt class="py-name">fields</tt><tt class="py-op">.</tt><tt id="link-69" class="py-name" targets="Method web2py.gluon.html.DIV.insert()=web2py.gluon.html.DIV-class.html#insert,Method web2py.gluon.sql.SQLTable.insert()=web2py.gluon.sql.SQLTable-class.html#insert"><a title="web2py.gluon.html.DIV.insert
web2py.gluon.sql.SQLTable.insert" class="py-name" href="#" onclick="return doclink('link-69', 'insert', 'link-69');">insert</a></tt><tt class="py-op">(</tt><tt class="py-number">0</tt><tt class="py-op">,</tt> <tt class="py-string">'id'</tt><tt class="py-op">)</tt> </tt>
<a name="L296"></a><tt class="py-lineno">296</tt>  <tt class="py-line">        <tt class="py-name">self</tt><tt class="py-op">.</tt><tt class="py-name">table</tt> <tt class="py-op">=</tt> <tt class="py-name">table</tt> </tt>
<a name="L297"></a><tt class="py-lineno">297</tt>  <tt class="py-line">        <tt class="py-keyword">if</tt> <tt class="py-name">record</tt> <tt class="py-keyword">and</tt> <tt class="py-name">isinstance</tt><tt class="py-op">(</tt><tt class="py-name">record</tt><tt class="py-op">,</tt> <tt class="py-op">(</tt><tt class="py-name">int</tt><tt class="py-op">,</tt> <tt class="py-name">long</tt><tt class="py-op">,</tt> <tt class="py-name">str</tt><tt class="py-op">,</tt> <tt class="py-name">unicode</tt><tt class="py-op">)</tt><tt class="py-op">)</tt><tt class="py-op">:</tt> </tt>
<a name="L298"></a><tt class="py-lineno">298</tt>  <tt class="py-line">            <tt class="py-name">records</tt> <tt class="py-op">=</tt> <tt class="py-name">table</tt><tt class="py-op">.</tt><tt class="py-name">_db</tt><tt class="py-op">(</tt><tt class="py-name">table</tt><tt class="py-op">.</tt><tt class="py-name">id</tt> <tt class="py-op">==</tt> <tt class="py-name">record</tt><tt class="py-op">)</tt><tt class="py-op">.</tt><tt id="link-70" class="py-name" targets="Method web2py.gluon.sql.SQLSet.select()=web2py.gluon.sql.SQLSet-class.html#select,Method web2py.gluon.tools.Crud.select()=web2py.gluon.tools.Crud-class.html#select"><a title="web2py.gluon.sql.SQLSet.select
web2py.gluon.tools.Crud.select" class="py-name" href="#" onclick="return doclink('link-70', 'select', 'link-70');">select</a></tt><tt class="py-op">(</tt><tt class="py-op">)</tt> </tt>
<a name="L299"></a><tt class="py-lineno">299</tt>  <tt class="py-line">            <tt class="py-keyword">if</tt> <tt class="py-name">records</tt><tt class="py-op">:</tt> </tt>
<a name="L300"></a><tt class="py-lineno">300</tt>  <tt class="py-line">                <tt class="py-name">record</tt> <tt class="py-op">=</tt> <tt class="py-name">records</tt><tt class="py-op">[</tt><tt class="py-number">0</tt><tt class="py-op">]</tt> </tt>
<a name="L301"></a><tt class="py-lineno">301</tt>  <tt class="py-line">            <tt class="py-keyword">else</tt><tt class="py-op">:</tt> </tt>
<a name="L302"></a><tt class="py-lineno">302</tt>  <tt class="py-line">                <tt class="py-name">record</tt> <tt class="py-op">=</tt> <tt class="py-name">None</tt> </tt>
<a name="L303"></a><tt class="py-lineno">303</tt>  <tt class="py-line">        <tt class="py-name">self</tt><tt class="py-op">.</tt><tt class="py-name">record</tt> <tt class="py-op">=</tt> <tt class="py-name">record</tt> </tt>
<a name="L304"></a><tt class="py-lineno">304</tt>  <tt class="py-line">        <tt class="py-name">self</tt><tt class="py-op">.</tt><tt class="py-name">record_id</tt> <tt class="py-op">=</tt> <tt class="py-name">None</tt> </tt>
<a name="L305"></a><tt class="py-lineno">305</tt>  <tt class="py-line">        <tt class="py-name">self</tt><tt class="py-op">.</tt><tt class="py-name">trows</tt> <tt class="py-op">=</tt> <tt class="py-op">{</tt><tt class="py-op">}</tt> </tt>
<a name="L306"></a><tt class="py-lineno">306</tt>  <tt class="py-line">        <tt class="py-name">xfields</tt> <tt class="py-op">=</tt> <tt class="py-op">[</tt><tt class="py-op">]</tt> </tt>
<a name="L307"></a><tt class="py-lineno">307</tt>  <tt class="py-line">        <tt class="py-name">self</tt><tt class="py-op">.</tt><tt class="py-name">fields</tt><tt class="py-op">=</tt><tt class="py-name">fields</tt> </tt>
<a name="L308"></a><tt class="py-lineno">308</tt>  <tt class="py-line">        <tt class="py-name">self</tt><tt class="py-op">.</tt><tt class="py-name">custom</tt><tt class="py-op">=</tt><tt id="link-71" class="py-name"><a title="web2py.gluon.storage.Storage" class="py-name" href="#" onclick="return doclink('link-71', 'Storage', 'link-6');">Storage</a></tt><tt class="py-op">(</tt><tt class="py-op">)</tt> </tt>
<a name="L309"></a><tt class="py-lineno">309</tt>  <tt class="py-line">        <tt class="py-name">self</tt><tt class="py-op">.</tt><tt class="py-name">custom</tt><tt class="py-op">.</tt><tt class="py-name">dspval</tt><tt class="py-op">=</tt><tt id="link-72" class="py-name"><a title="web2py.gluon.storage.Storage" class="py-name" href="#" onclick="return doclink('link-72', 'Storage', 'link-6');">Storage</a></tt><tt class="py-op">(</tt><tt class="py-op">)</tt> </tt>
<a name="L310"></a><tt class="py-lineno">310</tt>  <tt class="py-line">        <tt class="py-name">self</tt><tt class="py-op">.</tt><tt class="py-name">custom</tt><tt class="py-op">.</tt><tt class="py-name">inpval</tt><tt class="py-op">=</tt><tt id="link-73" class="py-name"><a title="web2py.gluon.storage.Storage" class="py-name" href="#" onclick="return doclink('link-73', 'Storage', 'link-6');">Storage</a></tt><tt class="py-op">(</tt><tt class="py-op">)</tt> </tt>
<a name="L311"></a><tt class="py-lineno">311</tt>  <tt class="py-line">        <tt class="py-name">self</tt><tt class="py-op">.</tt><tt class="py-name">custom</tt><tt class="py-op">.</tt><tt class="py-name">label</tt><tt class="py-op">=</tt><tt id="link-74" class="py-name"><a title="web2py.gluon.storage.Storage" class="py-name" href="#" onclick="return doclink('link-74', 'Storage', 'link-6');">Storage</a></tt><tt class="py-op">(</tt><tt class="py-op">)</tt> </tt>
<a name="L312"></a><tt class="py-lineno">312</tt>  <tt class="py-line">        <tt class="py-keyword">for</tt> <tt class="py-name">fieldname</tt> <tt class="py-keyword">in</tt> <tt class="py-name">self</tt><tt class="py-op">.</tt><tt class="py-name">fields</tt><tt class="py-op">:</tt> </tt>
<a name="L313"></a><tt class="py-lineno">313</tt>  <tt class="py-line">            <tt class="py-keyword">if</tt> <tt class="py-name">fieldname</tt><tt class="py-op">.</tt><tt class="py-name">find</tt><tt class="py-op">(</tt><tt class="py-string">'.'</tt><tt class="py-op">)</tt> <tt class="py-op">&gt;=</tt> <tt class="py-number">0</tt><tt class="py-op">:</tt> </tt>
<a name="L314"></a><tt class="py-lineno">314</tt>  <tt class="py-line">                <tt class="py-keyword">continue</tt> </tt>
<a name="L315"></a><tt class="py-lineno">315</tt>  <tt class="py-line">            <tt class="py-name">field</tt> <tt class="py-op">=</tt> <tt class="py-name">self</tt><tt class="py-op">.</tt><tt class="py-name">table</tt><tt class="py-op">[</tt><tt class="py-name">fieldname</tt><tt class="py-op">]</tt> </tt>
<a name="L316"></a><tt class="py-lineno">316</tt>  <tt class="py-line">            <tt class="py-keyword">if</tt> <tt class="py-name">comments</tt><tt class="py-op">:</tt> </tt>
<a name="L317"></a><tt class="py-lineno">317</tt>  <tt class="py-line">                <tt class="py-name">comment</tt> <tt class="py-op">=</tt> <tt class="py-name">col3</tt><tt class="py-op">.</tt><tt class="py-name">get</tt><tt class="py-op">(</tt><tt class="py-name">fieldname</tt><tt class="py-op">,</tt> <tt class="py-name">field</tt><tt class="py-op">.</tt><tt class="py-name">comment</tt><tt class="py-op">)</tt> <tt class="py-keyword">or</tt> <tt class="py-string">''</tt> </tt>
<a name="L318"></a><tt class="py-lineno">318</tt>  <tt class="py-line">            <tt class="py-keyword">else</tt><tt class="py-op">:</tt> </tt>
<a name="L319"></a><tt class="py-lineno">319</tt>  <tt class="py-line">                <tt class="py-name">comment</tt> <tt class="py-op">=</tt> <tt class="py-string">''</tt> </tt>
<a name="L320"></a><tt class="py-lineno">320</tt>  <tt class="py-line">            <tt class="py-keyword">if</tt> <tt class="py-name">labels</tt> <tt class="py-op">!=</tt> <tt class="py-name">None</tt> <tt class="py-keyword">and</tt> <tt class="py-name">labels</tt><tt class="py-op">.</tt><tt class="py-name">has_key</tt><tt class="py-op">(</tt><tt class="py-name">fieldname</tt><tt class="py-op">)</tt><tt class="py-op">:</tt> </tt>
<a name="L321"></a><tt class="py-lineno">321</tt>  <tt class="py-line">                <tt class="py-name">label</tt> <tt class="py-op">=</tt> <tt class="py-name">labels</tt><tt class="py-op">[</tt><tt class="py-name">fieldname</tt><tt class="py-op">]</tt> </tt>
<a name="L322"></a><tt class="py-lineno">322</tt>  <tt class="py-line">            <tt class="py-keyword">else</tt><tt class="py-op">:</tt> </tt>
<a name="L323"></a><tt class="py-lineno">323</tt>  <tt class="py-line">                <tt class="py-name">label</tt> <tt class="py-op">=</tt> <tt class="py-name">str</tt><tt class="py-op">(</tt><tt class="py-name">field</tt><tt class="py-op">.</tt><tt class="py-name">label</tt><tt class="py-op">)</tt> <tt class="py-op">+</tt> <tt class="py-string">': '</tt> </tt>
<a name="L324"></a><tt class="py-lineno">324</tt>  <tt class="py-line">            <tt class="py-name">self</tt><tt class="py-op">.</tt><tt class="py-name">custom</tt><tt class="py-op">.</tt><tt class="py-name">label</tt><tt class="py-op">[</tt><tt class="py-name">fieldname</tt><tt class="py-op">]</tt><tt class="py-op">=</tt><tt class="py-name">label</tt> </tt>
<a name="L325"></a><tt class="py-lineno">325</tt>  <tt class="py-line">            <tt class="py-name">field_id</tt> <tt class="py-op">=</tt> <tt class="py-string">'%s_%s'</tt> <tt class="py-op">%</tt> <tt class="py-op">(</tt><tt class="py-name">table</tt><tt class="py-op">.</tt><tt class="py-name">_tablename</tt><tt class="py-op">,</tt> <tt class="py-name">fieldname</tt><tt class="py-op">)</tt> </tt>
<a name="L326"></a><tt class="py-lineno">326</tt>  <tt class="py-line">            <tt class="py-name">label</tt> <tt class="py-op">=</tt> <tt id="link-75" class="py-name" targets="Class web2py.gluon.html.LABEL=web2py.gluon.html.LABEL-class.html"><a title="web2py.gluon.html.LABEL" class="py-name" href="#" onclick="return doclink('link-75', 'LABEL', 'link-75');">LABEL</a></tt><tt class="py-op">(</tt><tt class="py-name">label</tt><tt class="py-op">,</tt> <tt class="py-name">_for</tt><tt class="py-op">=</tt><tt class="py-name">field_id</tt><tt class="py-op">,</tt> <tt class="py-name">_id</tt><tt class="py-op">=</tt><tt class="py-string">'%s__label'</tt> <tt class="py-op">%</tt> <tt class="py-name">field_id</tt><tt class="py-op">)</tt> </tt>
<a name="L327"></a><tt class="py-lineno">327</tt>  <tt class="py-line">            <tt class="py-name">row_id</tt> <tt class="py-op">=</tt> <tt class="py-name">field_id</tt> <tt class="py-op">+</tt> <tt class="py-string">'__row'</tt> </tt>
<a name="L328"></a><tt class="py-lineno">328</tt>  <tt class="py-line">            <tt class="py-keyword">if</tt> <tt class="py-name">fieldname</tt> <tt class="py-op">==</tt> <tt class="py-string">'id'</tt><tt class="py-op">:</tt> </tt>
<a name="L329"></a><tt class="py-lineno">329</tt>  <tt class="py-line">                <tt class="py-name">self</tt><tt class="py-op">.</tt><tt class="py-name">custom</tt><tt class="py-op">.</tt><tt class="py-name">dspval</tt><tt class="py-op">.</tt><tt class="py-name">id</tt><tt class="py-op">=</tt><tt class="py-name">nbsp</tt> </tt>
<a name="L330"></a><tt class="py-lineno">330</tt>  <tt class="py-line">                <tt class="py-name">self</tt><tt class="py-op">.</tt><tt class="py-name">custom</tt><tt class="py-op">.</tt><tt class="py-name">inpval</tt><tt class="py-op">.</tt><tt class="py-name">id</tt><tt class="py-op">=</tt><tt class="py-string">''</tt> </tt>
<a name="L331"></a><tt class="py-lineno">331</tt>  <tt class="py-line">                <tt class="py-keyword">if</tt> <tt class="py-name">record</tt><tt class="py-op">:</tt> </tt>
<a name="L332"></a><tt class="py-lineno">332</tt>  <tt class="py-line">                    <tt class="py-keyword">if</tt> <tt class="py-name">showid</tt> <tt class="py-keyword">and</tt> <tt class="py-string">'id'</tt> <tt class="py-keyword">in</tt> <tt class="py-name">fields</tt> <tt class="py-keyword">and</tt> <tt class="py-name">field</tt><tt class="py-op">.</tt><tt class="py-name">readable</tt><tt class="py-op">:</tt> </tt>
<a name="L333"></a><tt class="py-lineno">333</tt>  <tt class="py-line">                        <tt class="py-name">v</tt><tt class="py-op">=</tt><tt class="py-name">record</tt><tt class="py-op">[</tt><tt class="py-string">'id'</tt><tt class="py-op">]</tt> </tt>
<a name="L334"></a><tt class="py-lineno">334</tt>  <tt class="py-line">                        <tt class="py-name">self</tt><tt class="py-op">.</tt><tt class="py-name">custom</tt><tt class="py-op">.</tt><tt class="py-name">dspval</tt><tt class="py-op">.</tt><tt class="py-name">id</tt><tt class="py-op">=</tt><tt class="py-name">str</tt><tt class="py-op">(</tt><tt class="py-name">v</tt><tt class="py-op">)</tt> </tt>
<a name="L335"></a><tt class="py-lineno">335</tt>  <tt class="py-line">                        <tt class="py-name">xfields</tt><tt class="py-op">.</tt><tt id="link-76" class="py-name" targets="Method web2py.gluon.html.DIV.append()=web2py.gluon.html.DIV-class.html#append"><a title="web2py.gluon.html.DIV.append" class="py-name" href="#" onclick="return doclink('link-76', 'append', 'link-76');">append</a></tt><tt class="py-op">(</tt><tt id="link-77" class="py-name" targets="Class web2py.gluon.html.TR=web2py.gluon.html.TR-class.html"><a title="web2py.gluon.html.TR" class="py-name" href="#" onclick="return doclink('link-77', 'TR', 'link-77');">TR</a></tt><tt class="py-op">(</tt><tt class="py-name">label</tt><tt class="py-op">,</tt> <tt id="link-78" class="py-name" targets="Class web2py.gluon.html.SPAN=web2py.gluon.html.SPAN-class.html"><a title="web2py.gluon.html.SPAN" class="py-name" href="#" onclick="return doclink('link-78', 'SPAN', 'link-78');">SPAN</a></tt><tt class="py-op">(</tt><tt class="py-name">v</tt><tt class="py-op">,</tt><tt class="py-name">_id</tt><tt class="py-op">=</tt><tt class="py-name">field_id</tt><tt class="py-op">)</tt><tt class="py-op">,</tt>  </tt>
<a name="L336"></a><tt class="py-lineno">336</tt>  <tt class="py-line">                                          <tt class="py-name">comment</tt><tt class="py-op">,</tt> <tt class="py-name">_id</tt><tt class="py-op">=</tt><tt class="py-string">'id__row'</tt><tt class="py-op">)</tt><tt class="py-op">)</tt> </tt>
<a name="L337"></a><tt class="py-lineno">337</tt>  <tt class="py-line">                    <tt class="py-name">self</tt><tt class="py-op">.</tt><tt class="py-name">record_id</tt> <tt class="py-op">=</tt> <tt class="py-name">str</tt><tt class="py-op">(</tt><tt class="py-name">record</tt><tt class="py-op">[</tt><tt class="py-string">'id'</tt><tt class="py-op">]</tt><tt class="py-op">)</tt> </tt>
<a name="L338"></a><tt class="py-lineno">338</tt>  <tt class="py-line">                <tt class="py-keyword">continue</tt> </tt>
<a name="L339"></a><tt class="py-lineno">339</tt>  <tt class="py-line">            <tt class="py-keyword">if</tt> <tt class="py-name">record</tt><tt class="py-op">:</tt> </tt>
<a name="L340"></a><tt class="py-lineno">340</tt>  <tt class="py-line">                <tt class="py-name">default</tt> <tt class="py-op">=</tt> <tt class="py-name">record</tt><tt class="py-op">[</tt><tt class="py-name">fieldname</tt><tt class="py-op">]</tt> </tt>
<a name="L341"></a><tt class="py-lineno">341</tt>  <tt class="py-line">            <tt class="py-keyword">else</tt><tt class="py-op">:</tt> </tt>
<a name="L342"></a><tt class="py-lineno">342</tt>  <tt class="py-line">                <tt class="py-name">default</tt> <tt class="py-op">=</tt> <tt class="py-name">field</tt><tt class="py-op">.</tt><tt class="py-name">default</tt> </tt>
<a name="L343"></a><tt class="py-lineno">343</tt>  <tt class="py-line">            <tt class="py-name">cond</tt> <tt class="py-op">=</tt> <tt class="py-name">readonly</tt> <tt class="py-keyword">or</tt> \ </tt>
<a name="L344"></a><tt class="py-lineno">344</tt>  <tt class="py-line">                <tt class="py-op">(</tt><tt class="py-keyword">not</tt> <tt class="py-name">ignore_rw</tt> <tt class="py-keyword">and</tt> <tt class="py-keyword">not</tt> <tt class="py-name">field</tt><tt class="py-op">.</tt><tt class="py-name">writable</tt> <tt class="py-keyword">and</tt> <tt class="py-name">field</tt><tt class="py-op">.</tt><tt class="py-name">readable</tt><tt class="py-op">)</tt> </tt>
<a name="L345"></a><tt class="py-lineno">345</tt>  <tt class="py-line">            <tt class="py-keyword">if</tt> <tt class="py-name">default</tt> <tt class="py-keyword">and</tt> <tt class="py-keyword">not</tt> <tt class="py-name">cond</tt><tt class="py-op">:</tt> </tt>
<a name="L346"></a><tt class="py-lineno">346</tt>  <tt class="py-line">                <tt class="py-name">default</tt> <tt class="py-op">=</tt> <tt class="py-name">field</tt><tt class="py-op">.</tt><tt id="link-79" class="py-name" targets="Method web2py.gluon.sql.SQLField.formatter()=web2py.gluon.sql.SQLField-class.html#formatter,Method web2py.gluon.validators.IS_DATE.formatter()=web2py.gluon.validators.IS_DATE-class.html#formatter,Method web2py.gluon.validators.IS_DATETIME.formatter()=web2py.gluon.validators.IS_DATETIME-class.html#formatter,Method web2py.gluon.validators.IS_NULL_OR.formatter()=web2py.gluon.validators.IS_NULL_OR-class.html#formatter"><a title="web2py.gluon.sql.SQLField.formatter
web2py.gluon.validators.IS_DATE.formatter
web2py.gluon.validators.IS_DATETIME.formatter
web2py.gluon.validators.IS_NULL_OR.formatter" class="py-name" href="#" onclick="return doclink('link-79', 'formatter', 'link-79');">formatter</a></tt><tt class="py-op">(</tt><tt class="py-name">default</tt><tt class="py-op">)</tt> </tt>
<a name="L347"></a><tt class="py-lineno">347</tt>  <tt class="py-line">            <tt class="py-name">dspval</tt><tt class="py-op">=</tt><tt class="py-name">default</tt> </tt>
<a name="L348"></a><tt class="py-lineno">348</tt>  <tt class="py-line">            <tt class="py-name">inpval</tt><tt class="py-op">=</tt><tt class="py-name">default</tt> </tt>
<a name="L349"></a><tt class="py-lineno">349</tt>  <tt class="py-line">            <tt class="py-keyword">if</tt> <tt class="py-name">cond</tt><tt class="py-op">:</tt> </tt>
<a name="L350"></a><tt class="py-lineno">350</tt>  <tt class="py-line"> </tt>
<a name="L351"></a><tt class="py-lineno">351</tt>  <tt class="py-line">                <tt class="py-comment"># ## if field.represent is available else</tt> </tt>
<a name="L352"></a><tt class="py-lineno">352</tt>  <tt class="py-line"><tt class="py-comment"></tt>                <tt class="py-comment"># ## ignore blob and preview uploaded images</tt> </tt>
<a name="L353"></a><tt class="py-lineno">353</tt>  <tt class="py-line"><tt class="py-comment"></tt>                <tt class="py-comment"># ## format everything else</tt> </tt>
<a name="L354"></a><tt class="py-lineno">354</tt>  <tt class="py-line"><tt class="py-comment"></tt> </tt>
<a name="L355"></a><tt class="py-lineno">355</tt>  <tt class="py-line">                <tt class="py-keyword">if</tt> <tt class="py-name">field</tt><tt class="py-op">.</tt><tt id="link-80" class="py-name" targets="Static Method web2py.gluon.sqlhtml.UploadWidget.represent()=web2py.gluon.sqlhtml.UploadWidget-class.html#represent"><a title="web2py.gluon.sqlhtml.UploadWidget.represent" class="py-name" href="#" onclick="return doclink('link-80', 'represent', 'link-80');">represent</a></tt><tt class="py-op">:</tt> </tt>
<a name="L356"></a><tt class="py-lineno">356</tt>  <tt class="py-line">                    <tt class="py-name">inp</tt> <tt class="py-op">=</tt> <tt class="py-name">field</tt><tt class="py-op">.</tt><tt id="link-81" class="py-name"><a title="web2py.gluon.sqlhtml.UploadWidget.represent" class="py-name" href="#" onclick="return doclink('link-81', 'represent', 'link-80');">represent</a></tt><tt class="py-op">(</tt><tt class="py-name">default</tt><tt class="py-op">)</tt> </tt>
<a name="L357"></a><tt class="py-lineno">357</tt>  <tt class="py-line">                <tt class="py-keyword">elif</tt> <tt class="py-name">field</tt><tt class="py-op">.</tt><tt class="py-name">type</tt> <tt class="py-keyword">in</tt> <tt class="py-op">[</tt><tt class="py-string">'blob'</tt><tt class="py-op">]</tt><tt class="py-op">:</tt> </tt>
<a name="L358"></a><tt class="py-lineno">358</tt>  <tt class="py-line">                    <tt class="py-keyword">continue</tt> </tt>
<a name="L359"></a><tt class="py-lineno">359</tt>  <tt class="py-line">                <tt class="py-keyword">elif</tt> <tt class="py-name">field</tt><tt class="py-op">.</tt><tt class="py-name">type</tt> <tt class="py-op">==</tt> <tt class="py-string">'upload'</tt><tt class="py-op">:</tt> </tt>
<a name="L360"></a><tt class="py-lineno">360</tt>  <tt class="py-line">                    <tt class="py-name">inp</tt> <tt class="py-op">=</tt> <tt id="link-82" class="py-name"><a title="web2py.gluon.sqlhtml.UploadWidget" class="py-name" href="#" onclick="return doclink('link-82', 'UploadWidget', 'link-34');">UploadWidget</a></tt><tt class="py-op">.</tt><tt id="link-83" class="py-name"><a title="web2py.gluon.sqlhtml.UploadWidget.represent" class="py-name" href="#" onclick="return doclink('link-83', 'represent', 'link-80');">represent</a></tt><tt class="py-op">(</tt><tt class="py-name">field</tt><tt class="py-op">,</tt> <tt class="py-name">default</tt><tt class="py-op">,</tt> <tt class="py-name">upload</tt><tt class="py-op">)</tt> </tt>
<a name="L361"></a><tt class="py-lineno">361</tt>  <tt class="py-line">                <tt class="py-keyword">else</tt><tt class="py-op">:</tt> </tt>
<a name="L362"></a><tt class="py-lineno">362</tt>  <tt class="py-line">                    <tt class="py-name">inp</tt> <tt class="py-op">=</tt> <tt class="py-name">field</tt><tt class="py-op">.</tt><tt id="link-84" class="py-name"><a title="web2py.gluon.sql.SQLField.formatter
web2py.gluon.validators.IS_DATE.formatter
web2py.gluon.validators.IS_DATETIME.formatter
web2py.gluon.validators.IS_NULL_OR.formatter" class="py-name" href="#" onclick="return doclink('link-84', 'formatter', 'link-79');">formatter</a></tt><tt class="py-op">(</tt><tt class="py-name">default</tt><tt class="py-op">)</tt> </tt>
<a name="L363"></a><tt class="py-lineno">363</tt>  <tt class="py-line">            <tt class="py-keyword">elif</tt> <tt class="py-name">hasattr</tt><tt class="py-op">(</tt><tt class="py-name">field</tt><tt class="py-op">,</tt> <tt class="py-string">'widget'</tt><tt class="py-op">)</tt> <tt class="py-keyword">and</tt> <tt class="py-name">field</tt><tt class="py-op">.</tt><tt id="link-85" class="py-name" targets="Static Method web2py.gluon.sqlhtml.BooleanWidget.widget()=web2py.gluon.sqlhtml.BooleanWidget-class.html#widget,Static Method web2py.gluon.sqlhtml.MultipleOptionsWidget.widget()=web2py.gluon.sqlhtml.MultipleOptionsWidget-class.html#widget,Static Method web2py.gluon.sqlhtml.OptionsWidget.widget()=web2py.gluon.sqlhtml.OptionsWidget-class.html#widget,Static Method web2py.gluon.sqlhtml.PasswordWidget.widget()=web2py.gluon.sqlhtml.PasswordWidget-class.html#widget,Static Method web2py.gluon.sqlhtml.StringWidget.widget()=web2py.gluon.sqlhtml.StringWidget-class.html#widget,Static Method web2py.gluon.sqlhtml.TextWidget.widget()=web2py.gluon.sqlhtml.TextWidget-class.html#widget,Static Method web2py.gluon.sqlhtml.UploadWidget.widget()=web2py.gluon.sqlhtml.UploadWidget-class.html#widget,Module web2py.gluon.widget=web2py.gluon.widget-module.html"><a title="web2py.gluon.sqlhtml.BooleanWidget.widget
web2py.gluon.sqlhtml.MultipleOptionsWidget.widget
web2py.gluon.sqlhtml.OptionsWidget.widget
web2py.gluon.sqlhtml.PasswordWidget.widget
web2py.gluon.sqlhtml.StringWidget.widget
web2py.gluon.sqlhtml.TextWidget.widget
web2py.gluon.sqlhtml.UploadWidget.widget
web2py.gluon.widget" class="py-name" href="#" onclick="return doclink('link-85', 'widget', 'link-85');">widget</a></tt><tt class="py-op">:</tt> </tt>
<a name="L364"></a><tt class="py-lineno">364</tt>  <tt class="py-line">                <tt class="py-name">inp</tt> <tt class="py-op">=</tt> <tt class="py-name">field</tt><tt class="py-op">.</tt><tt id="link-86" class="py-name"><a title="web2py.gluon.sqlhtml.BooleanWidget.widget
web2py.gluon.sqlhtml.MultipleOptionsWidget.widget
web2py.gluon.sqlhtml.OptionsWidget.widget
web2py.gluon.sqlhtml.PasswordWidget.widget
web2py.gluon.sqlhtml.StringWidget.widget
web2py.gluon.sqlhtml.TextWidget.widget
web2py.gluon.sqlhtml.UploadWidget.widget
web2py.gluon.widget" class="py-name" href="#" onclick="return doclink('link-86', 'widget', 'link-85');">widget</a></tt><tt class="py-op">(</tt><tt class="py-name">field</tt><tt class="py-op">,</tt> <tt class="py-name">default</tt><tt class="py-op">)</tt> </tt>
<a name="L365"></a><tt class="py-lineno">365</tt>  <tt class="py-line">            <tt class="py-keyword">elif</tt> <tt class="py-name">field</tt><tt class="py-op">.</tt><tt class="py-name">type</tt> <tt class="py-op">==</tt> <tt class="py-string">'upload'</tt><tt class="py-op">:</tt> </tt>
<a name="L366"></a><tt class="py-lineno">366</tt>  <tt class="py-line">                <tt class="py-name">inp</tt> <tt class="py-op">=</tt> <tt class="py-name">self</tt><tt class="py-op">.</tt><tt id="link-87" class="py-name"><a title="web2py.gluon.sqlhtml.SQLFORM.widgets" class="py-name" href="#" onclick="return doclink('link-87', 'widgets', 'link-47');">widgets</a></tt><tt class="py-op">.</tt><tt class="py-name">upload</tt><tt class="py-op">.</tt><tt id="link-88" class="py-name"><a title="web2py.gluon.sqlhtml.BooleanWidget.widget
web2py.gluon.sqlhtml.MultipleOptionsWidget.widget
web2py.gluon.sqlhtml.OptionsWidget.widget
web2py.gluon.sqlhtml.PasswordWidget.widget
web2py.gluon.sqlhtml.StringWidget.widget
web2py.gluon.sqlhtml.TextWidget.widget
web2py.gluon.sqlhtml.UploadWidget.widget
web2py.gluon.widget" class="py-name" href="#" onclick="return doclink('link-88', 'widget', 'link-85');">widget</a></tt><tt class="py-op">(</tt><tt class="py-name">field</tt><tt class="py-op">,</tt> <tt class="py-name">default</tt><tt class="py-op">,</tt> <tt class="py-name">upload</tt><tt class="py-op">)</tt> </tt>
<a name="L367"></a><tt class="py-lineno">367</tt>  <tt class="py-line">            <tt class="py-keyword">elif</tt> <tt class="py-name">field</tt><tt class="py-op">.</tt><tt class="py-name">type</tt> <tt class="py-op">==</tt> <tt class="py-string">'boolean'</tt><tt class="py-op">:</tt> </tt>
<a name="L368"></a><tt class="py-lineno">368</tt>  <tt class="py-line">                <tt class="py-name">inp</tt> <tt class="py-op">=</tt> <tt class="py-name">self</tt><tt class="py-op">.</tt><tt id="link-89" class="py-name"><a title="web2py.gluon.sqlhtml.SQLFORM.widgets" class="py-name" href="#" onclick="return doclink('link-89', 'widgets', 'link-47');">widgets</a></tt><tt class="py-op">.</tt><tt class="py-name">boolean</tt><tt class="py-op">.</tt><tt id="link-90" class="py-name"><a title="web2py.gluon.sqlhtml.BooleanWidget.widget
web2py.gluon.sqlhtml.MultipleOptionsWidget.widget
web2py.gluon.sqlhtml.OptionsWidget.widget
web2py.gluon.sqlhtml.PasswordWidget.widget
web2py.gluon.sqlhtml.StringWidget.widget
web2py.gluon.sqlhtml.TextWidget.widget
web2py.gluon.sqlhtml.UploadWidget.widget
web2py.gluon.widget" class="py-name" href="#" onclick="return doclink('link-90', 'widget', 'link-85');">widget</a></tt><tt class="py-op">(</tt><tt class="py-name">field</tt><tt class="py-op">,</tt> <tt class="py-name">default</tt><tt class="py-op">)</tt> </tt>
<a name="L369"></a><tt class="py-lineno">369</tt>  <tt class="py-line">                <tt class="py-keyword">if</tt> <tt class="py-name">default</tt><tt class="py-op">:</tt> </tt>
<a name="L370"></a><tt class="py-lineno">370</tt>  <tt class="py-line">                  <tt class="py-name">inpval</tt><tt class="py-op">=</tt><tt class="py-string">'checked'</tt> </tt>
<a name="L371"></a><tt class="py-lineno">371</tt>  <tt class="py-line">                <tt class="py-keyword">else</tt><tt class="py-op">:</tt> </tt>
<a name="L372"></a><tt class="py-lineno">372</tt>  <tt class="py-line">                  <tt class="py-name">inpval</tt><tt class="py-op">=</tt><tt class="py-string">''</tt> </tt>
<a name="L373"></a><tt class="py-lineno">373</tt>  <tt class="py-line">            <tt class="py-keyword">elif</tt> <tt id="link-91" class="py-name"><a title="web2py.gluon.sqlhtml.OptionsWidget" class="py-name" href="#" onclick="return doclink('link-91', 'OptionsWidget', 'link-60');">OptionsWidget</a></tt><tt class="py-op">.</tt><tt id="link-92" class="py-name" targets="Static Method web2py.gluon.sqlhtml.OptionsWidget.has_options()=web2py.gluon.sqlhtml.OptionsWidget-class.html#has_options"><a title="web2py.gluon.sqlhtml.OptionsWidget.has_options" class="py-name" href="#" onclick="return doclink('link-92', 'has_options', 'link-92');">has_options</a></tt><tt class="py-op">(</tt><tt class="py-name">field</tt><tt class="py-op">)</tt><tt class="py-op">:</tt> </tt>
<a name="L374"></a><tt class="py-lineno">374</tt>  <tt class="py-line">                <tt class="py-keyword">if</tt> <tt class="py-keyword">not</tt> <tt class="py-name">field</tt><tt class="py-op">.</tt><tt class="py-name">requires</tt><tt class="py-op">.</tt><tt class="py-name">multiple</tt><tt class="py-op">:</tt> </tt>
<a name="L375"></a><tt class="py-lineno">375</tt>  <tt class="py-line">                    <tt class="py-name">inp</tt> <tt class="py-op">=</tt> <tt class="py-name">self</tt><tt class="py-op">.</tt><tt id="link-93" class="py-name"><a title="web2py.gluon.sqlhtml.SQLFORM.widgets" class="py-name" href="#" onclick="return doclink('link-93', 'widgets', 'link-47');">widgets</a></tt><tt class="py-op">.</tt><tt id="link-94" class="py-name"><a title="web2py.gluon.validators.IS_IN_DB.options
web2py.gluon.validators.IS_IN_SET.options" class="py-name" href="#" onclick="return doclink('link-94', 'options', 'link-15');">options</a></tt><tt class="py-op">.</tt><tt id="link-95" class="py-name"><a title="web2py.gluon.sqlhtml.BooleanWidget.widget
web2py.gluon.sqlhtml.MultipleOptionsWidget.widget
web2py.gluon.sqlhtml.OptionsWidget.widget
web2py.gluon.sqlhtml.PasswordWidget.widget
web2py.gluon.sqlhtml.StringWidget.widget
web2py.gluon.sqlhtml.TextWidget.widget
web2py.gluon.sqlhtml.UploadWidget.widget
web2py.gluon.widget" class="py-name" href="#" onclick="return doclink('link-95', 'widget', 'link-85');">widget</a></tt><tt class="py-op">(</tt><tt class="py-name">field</tt><tt class="py-op">,</tt> <tt class="py-name">default</tt><tt class="py-op">)</tt> </tt>
<a name="L376"></a><tt class="py-lineno">376</tt>  <tt class="py-line">                <tt class="py-keyword">else</tt><tt class="py-op">:</tt> </tt>
<a name="L377"></a><tt class="py-lineno">377</tt>  <tt class="py-line">                    <tt class="py-name">inp</tt> <tt class="py-op">=</tt> <tt class="py-name">self</tt><tt class="py-op">.</tt><tt id="link-96" class="py-name"><a title="web2py.gluon.sqlhtml.SQLFORM.widgets" class="py-name" href="#" onclick="return doclink('link-96', 'widgets', 'link-47');">widgets</a></tt><tt class="py-op">.</tt><tt class="py-name">multiple</tt><tt class="py-op">.</tt><tt id="link-97" class="py-name"><a title="web2py.gluon.sqlhtml.BooleanWidget.widget
web2py.gluon.sqlhtml.MultipleOptionsWidget.widget
web2py.gluon.sqlhtml.OptionsWidget.widget
web2py.gluon.sqlhtml.PasswordWidget.widget
web2py.gluon.sqlhtml.StringWidget.widget
web2py.gluon.sqlhtml.TextWidget.widget
web2py.gluon.sqlhtml.UploadWidget.widget
web2py.gluon.widget" class="py-name" href="#" onclick="return doclink('link-97', 'widget', 'link-85');">widget</a></tt><tt class="py-op">(</tt><tt class="py-name">field</tt><tt class="py-op">,</tt> <tt class="py-name">default</tt><tt class="py-op">)</tt> </tt>
<a name="L378"></a><tt class="py-lineno">378</tt>  <tt class="py-line">                <tt class="py-keyword">if</tt> <tt class="py-name">fieldname</tt> <tt class="py-keyword">in</tt> <tt class="py-name">keepopts</tt><tt class="py-op">:</tt> </tt>
<a name="L379"></a><tt class="py-lineno">379</tt>  <tt class="py-line">                    <tt class="py-name">inpval</tt><tt class="py-op">=</tt><tt id="link-98" class="py-name" targets="Variable web2py.gluon.html.TAG=web2py.gluon.html-module.html#TAG,Variable web2py.gluon.sqlhtml.TAG=web2py.gluon.sqlhtml-module.html#TAG,Variable web2py.gluon.tools.TAG=web2py.gluon.tools-module.html#TAG"><a title="web2py.gluon.html.TAG
web2py.gluon.sqlhtml.TAG
web2py.gluon.tools.TAG" class="py-name" href="#" onclick="return doclink('link-98', 'TAG', 'link-98');">TAG</a></tt><tt class="py-op">[</tt><tt class="py-string">''</tt><tt class="py-op">]</tt><tt class="py-op">(</tt><tt class="py-op">*</tt><tt class="py-name">inp</tt><tt class="py-op">.</tt><tt class="py-name">components</tt><tt class="py-op">)</tt> </tt>
<a name="L380"></a><tt class="py-lineno">380</tt>  <tt class="py-line">            <tt class="py-keyword">elif</tt> <tt class="py-name">field</tt><tt class="py-op">.</tt><tt class="py-name">type</tt> <tt class="py-op">==</tt> <tt class="py-string">'text'</tt><tt class="py-op">:</tt> </tt>
<a name="L381"></a><tt class="py-lineno">381</tt>  <tt class="py-line">                <tt class="py-name">inp</tt> <tt class="py-op">=</tt> <tt class="py-name">self</tt><tt class="py-op">.</tt><tt id="link-99" class="py-name"><a title="web2py.gluon.sqlhtml.SQLFORM.widgets" class="py-name" href="#" onclick="return doclink('link-99', 'widgets', 'link-47');">widgets</a></tt><tt class="py-op">.</tt><tt class="py-name">text</tt><tt class="py-op">.</tt><tt id="link-100" class="py-name"><a title="web2py.gluon.sqlhtml.BooleanWidget.widget
web2py.gluon.sqlhtml.MultipleOptionsWidget.widget
web2py.gluon.sqlhtml.OptionsWidget.widget
web2py.gluon.sqlhtml.PasswordWidget.widget
web2py.gluon.sqlhtml.StringWidget.widget
web2py.gluon.sqlhtml.TextWidget.widget
web2py.gluon.sqlhtml.UploadWidget.widget
web2py.gluon.widget" class="py-name" href="#" onclick="return doclink('link-100', 'widget', 'link-85');">widget</a></tt><tt class="py-op">(</tt><tt class="py-name">field</tt><tt class="py-op">,</tt> <tt class="py-name">default</tt><tt class="py-op">)</tt> </tt>
<a name="L382"></a><tt class="py-lineno">382</tt>  <tt class="py-line">            <tt class="py-keyword">elif</tt> <tt class="py-name">field</tt><tt class="py-op">.</tt><tt class="py-name">type</tt> <tt class="py-op">==</tt> <tt class="py-string">'password'</tt><tt class="py-op">:</tt> </tt>
<a name="L383"></a><tt class="py-lineno">383</tt>  <tt class="py-line">                <tt class="py-name">inp</tt> <tt class="py-op">=</tt> <tt class="py-name">self</tt><tt class="py-op">.</tt><tt id="link-101" class="py-name"><a title="web2py.gluon.sqlhtml.SQLFORM.widgets" class="py-name" href="#" onclick="return doclink('link-101', 'widgets', 'link-47');">widgets</a></tt><tt class="py-op">.</tt><tt class="py-name">password</tt><tt class="py-op">.</tt><tt id="link-102" class="py-name"><a title="web2py.gluon.sqlhtml.BooleanWidget.widget
web2py.gluon.sqlhtml.MultipleOptionsWidget.widget
web2py.gluon.sqlhtml.OptionsWidget.widget
web2py.gluon.sqlhtml.PasswordWidget.widget
web2py.gluon.sqlhtml.StringWidget.widget
web2py.gluon.sqlhtml.TextWidget.widget
web2py.gluon.sqlhtml.UploadWidget.widget
web2py.gluon.widget" class="py-name" href="#" onclick="return doclink('link-102', 'widget', 'link-85');">widget</a></tt><tt class="py-op">(</tt><tt class="py-name">field</tt><tt class="py-op">,</tt> <tt class="py-name">default</tt><tt class="py-op">)</tt> </tt>
<a name="L384"></a><tt class="py-lineno">384</tt>  <tt class="py-line">                <tt class="py-keyword">if</tt> <tt class="py-name">self</tt><tt class="py-op">.</tt><tt class="py-name">record</tt><tt class="py-op">:</tt> </tt>
<a name="L385"></a><tt class="py-lineno">385</tt>  <tt class="py-line">                    <tt class="py-name">dspval</tt><tt class="py-op">=</tt><tt class="py-string">'********'</tt> </tt>
<a name="L386"></a><tt class="py-lineno">386</tt>  <tt class="py-line">                <tt class="py-keyword">else</tt><tt class="py-op">:</tt> </tt>
<a name="L387"></a><tt class="py-lineno">387</tt>  <tt class="py-line">                    <tt class="py-name">dspval</tt><tt class="py-op">=</tt><tt class="py-string">''</tt> </tt>
<a name="L388"></a><tt class="py-lineno">388</tt>  <tt class="py-line">            <tt class="py-keyword">elif</tt> <tt class="py-name">field</tt><tt class="py-op">.</tt><tt class="py-name">type</tt> <tt class="py-op">==</tt> <tt class="py-string">'blob'</tt><tt class="py-op">:</tt> </tt>
<a name="L389"></a><tt class="py-lineno">389</tt>  <tt class="py-line">                <tt class="py-keyword">continue</tt> </tt>
<a name="L390"></a><tt class="py-lineno">390</tt>  <tt class="py-line">            <tt class="py-keyword">else</tt><tt class="py-op">:</tt> </tt>
<a name="L391"></a><tt class="py-lineno">391</tt>  <tt class="py-line">                <tt class="py-name">inp</tt> <tt class="py-op">=</tt> <tt class="py-name">self</tt><tt class="py-op">.</tt><tt id="link-103" class="py-name"><a title="web2py.gluon.sqlhtml.SQLFORM.widgets" class="py-name" href="#" onclick="return doclink('link-103', 'widgets', 'link-47');">widgets</a></tt><tt class="py-op">.</tt><tt class="py-name">string</tt><tt class="py-op">.</tt><tt id="link-104" class="py-name"><a title="web2py.gluon.sqlhtml.BooleanWidget.widget
web2py.gluon.sqlhtml.MultipleOptionsWidget.widget
web2py.gluon.sqlhtml.OptionsWidget.widget
web2py.gluon.sqlhtml.PasswordWidget.widget
web2py.gluon.sqlhtml.StringWidget.widget
web2py.gluon.sqlhtml.TextWidget.widget
web2py.gluon.sqlhtml.UploadWidget.widget
web2py.gluon.widget" class="py-name" href="#" onclick="return doclink('link-104', 'widget', 'link-85');">widget</a></tt><tt class="py-op">(</tt><tt class="py-name">field</tt><tt class="py-op">,</tt> <tt class="py-name">default</tt><tt class="py-op">)</tt> </tt>
<a name="L392"></a><tt class="py-lineno">392</tt>  <tt class="py-line">            <tt class="py-name">tr</tt> <tt class="py-op">=</tt> <tt class="py-name">self</tt><tt class="py-op">.</tt><tt class="py-name">trows</tt><tt class="py-op">[</tt><tt class="py-name">fieldname</tt><tt class="py-op">]</tt> <tt class="py-op">=</tt> <tt id="link-105" class="py-name"><a title="web2py.gluon.html.TR" class="py-name" href="#" onclick="return doclink('link-105', 'TR', 'link-77');">TR</a></tt><tt class="py-op">(</tt><tt class="py-name">label</tt><tt class="py-op">,</tt> <tt class="py-name">inp</tt><tt class="py-op">,</tt> <tt class="py-name">comment</tt><tt class="py-op">,</tt> </tt>
<a name="L393"></a><tt class="py-lineno">393</tt>  <tt class="py-line">                    <tt class="py-name">_id</tt><tt class="py-op">=</tt><tt class="py-name">row_id</tt><tt class="py-op">)</tt> </tt>
<a name="L394"></a><tt class="py-lineno">394</tt>  <tt class="py-line">            <tt class="py-name">xfields</tt><tt class="py-op">.</tt><tt id="link-106" class="py-name"><a title="web2py.gluon.html.DIV.append" class="py-name" href="#" onclick="return doclink('link-106', 'append', 'link-76');">append</a></tt><tt class="py-op">(</tt><tt class="py-name">tr</tt><tt class="py-op">)</tt> </tt>
<a name="L395"></a><tt class="py-lineno">395</tt>  <tt class="py-line">            <tt class="py-name">self</tt><tt class="py-op">.</tt><tt class="py-name">custom</tt><tt class="py-op">.</tt><tt class="py-name">dspval</tt><tt class="py-op">[</tt><tt class="py-name">fieldname</tt><tt class="py-op">]</tt><tt class="py-op">=</tt><tt class="py-name">dspval</tt> <tt class="py-keyword">or</tt> <tt class="py-name">nbsp</tt> </tt>
<a name="L396"></a><tt class="py-lineno">396</tt>  <tt class="py-line">            <tt class="py-name">self</tt><tt class="py-op">.</tt><tt class="py-name">custom</tt><tt class="py-op">.</tt><tt class="py-name">inpval</tt><tt class="py-op">[</tt><tt class="py-name">fieldname</tt><tt class="py-op">]</tt><tt class="py-op">=</tt><tt class="py-name">inpval</tt> <tt class="py-keyword">or</tt> <tt class="py-string">''</tt> </tt>
<a name="L397"></a><tt class="py-lineno">397</tt>  <tt class="py-line">        <tt class="py-keyword">if</tt> <tt class="py-name">record</tt> <tt class="py-keyword">and</tt> <tt class="py-name">linkto</tt><tt class="py-op">:</tt> </tt>
<a name="L398"></a><tt class="py-lineno">398</tt>  <tt class="py-line">            <tt class="py-keyword">for</tt> <tt class="py-op">(</tt><tt class="py-name">rtable</tt><tt class="py-op">,</tt> <tt class="py-name">rfield</tt><tt class="py-op">)</tt> <tt class="py-keyword">in</tt> <tt class="py-name">table</tt><tt class="py-op">.</tt><tt class="py-name">_referenced_by</tt><tt class="py-op">:</tt> </tt>
<a name="L399"></a><tt class="py-lineno">399</tt>  <tt class="py-line">                <tt class="py-name">query</tt> <tt class="py-op">=</tt> <tt class="py-name">urllib</tt><tt class="py-op">.</tt><tt class="py-name">quote</tt><tt class="py-op">(</tt><tt class="py-name">str</tt><tt class="py-op">(</tt><tt class="py-name">table</tt><tt class="py-op">.</tt><tt class="py-name">_db</tt><tt class="py-op">[</tt><tt class="py-name">rtable</tt><tt class="py-op">]</tt><tt class="py-op">[</tt><tt class="py-name">rfield</tt><tt class="py-op">]</tt> </tt>
<a name="L400"></a><tt class="py-lineno">400</tt>  <tt class="py-line">                         <tt class="py-op">==</tt> <tt class="py-name">record</tt><tt class="py-op">.</tt><tt class="py-name">id</tt><tt class="py-op">)</tt><tt class="py-op">)</tt> </tt>
<a name="L401"></a><tt class="py-lineno">401</tt>  <tt class="py-line">                <tt class="py-name">lname</tt> <tt class="py-op">=</tt> <tt class="py-name">olname</tt> <tt class="py-op">=</tt> <tt class="py-string">'%s.%s'</tt> <tt class="py-op">%</tt> <tt class="py-op">(</tt><tt class="py-name">rtable</tt><tt class="py-op">,</tt> <tt class="py-name">rfield</tt><tt class="py-op">)</tt> </tt>
<a name="L402"></a><tt class="py-lineno">402</tt>  <tt class="py-line">                <tt class="py-keyword">if</tt> <tt class="py-name">ofields</tt> <tt class="py-keyword">and</tt> <tt class="py-keyword">not</tt> <tt class="py-name">olname</tt> <tt class="py-keyword">in</tt> <tt class="py-name">ofields</tt><tt class="py-op">:</tt> </tt>
<a name="L403"></a><tt class="py-lineno">403</tt>  <tt class="py-line">                     <tt class="py-keyword">continue</tt> </tt>
<a name="L404"></a><tt class="py-lineno">404</tt>  <tt class="py-line">                <tt class="py-keyword">if</tt> <tt class="py-name">labels</tt> <tt class="py-keyword">and</tt> <tt class="py-name">labels</tt><tt class="py-op">.</tt><tt class="py-name">has_key</tt><tt class="py-op">(</tt><tt class="py-name">lname</tt><tt class="py-op">)</tt><tt class="py-op">:</tt> </tt>
<a name="L405"></a><tt class="py-lineno">405</tt>  <tt class="py-line">                    <tt class="py-name">lname</tt> <tt class="py-op">=</tt> <tt class="py-name">labels</tt><tt class="py-op">[</tt><tt class="py-name">lname</tt><tt class="py-op">]</tt> </tt>
<a name="L406"></a><tt class="py-lineno">406</tt>  <tt class="py-line">                <tt class="py-name">xfields</tt><tt class="py-op">.</tt><tt id="link-107" class="py-name"><a title="web2py.gluon.html.DIV.append" class="py-name" href="#" onclick="return doclink('link-107', 'append', 'link-76');">append</a></tt><tt class="py-op">(</tt><tt id="link-108" class="py-name"><a title="web2py.gluon.html.TR" class="py-name" href="#" onclick="return doclink('link-108', 'TR', 'link-77');">TR</a></tt><tt class="py-op">(</tt><tt class="py-string">''</tt><tt class="py-op">,</tt> <tt id="link-109" class="py-name"><a title="web2py.gluon.html.A" class="py-name" href="#" onclick="return doclink('link-109', 'A', 'link-39');">A</a></tt><tt class="py-op">(</tt><tt class="py-name">lname</tt><tt class="py-op">,</tt> <tt class="py-name">_class</tt><tt class="py-op">=</tt><tt class="py-string">'reference'</tt><tt class="py-op">,</tt> </tt>
<a name="L407"></a><tt class="py-lineno">407</tt>  <tt class="py-line">                                  <tt class="py-name">_href</tt><tt class="py-op">=</tt><tt class="py-string">'%s/%s?query=%s'</tt> <tt class="py-op">%</tt> <tt class="py-op">(</tt><tt class="py-name">linkto</tt><tt class="py-op">,</tt> </tt>
<a name="L408"></a><tt class="py-lineno">408</tt>  <tt class="py-line">                                  <tt class="py-name">rtable</tt><tt class="py-op">,</tt> <tt class="py-name">query</tt><tt class="py-op">)</tt><tt class="py-op">)</tt><tt class="py-op">,</tt> <tt class="py-name">col3</tt><tt class="py-op">.</tt><tt class="py-name">get</tt><tt class="py-op">(</tt><tt class="py-name">olname</tt><tt class="py-op">,</tt> <tt class="py-string">''</tt> </tt>
<a name="L409"></a><tt class="py-lineno">409</tt>  <tt class="py-line">                                  <tt class="py-op">)</tt><tt class="py-op">,</tt> <tt class="py-name">_id</tt><tt class="py-op">=</tt><tt class="py-string">'%s__row'</tt> <tt class="py-op">%</tt> <tt class="py-name">olname</tt><tt class="py-op">.</tt><tt id="link-110" class="py-name" targets="Function web2py.gluon.template.replace()=web2py.gluon.template-module.html#replace"><a title="web2py.gluon.template.replace" class="py-name" href="#" onclick="return doclink('link-110', 'replace', 'link-110');">replace</a></tt><tt class="py-op">(</tt><tt class="py-string">'.'</tt> </tt>
<a name="L410"></a><tt class="py-lineno">410</tt>  <tt class="py-line">                                  <tt class="py-op">,</tt> <tt class="py-string">'__'</tt><tt class="py-op">)</tt><tt class="py-op">)</tt><tt class="py-op">)</tt> </tt>
<a name="L411"></a><tt class="py-lineno">411</tt>  <tt class="py-line">        <tt class="py-keyword">if</tt> <tt class="py-name">record</tt> <tt class="py-keyword">and</tt> <tt class="py-name">deletable</tt><tt class="py-op">:</tt> </tt>
<a name="L412"></a><tt class="py-lineno">412</tt>  <tt class="py-line">            <tt class="py-name">xfields</tt><tt class="py-op">.</tt><tt id="link-111" class="py-name"><a title="web2py.gluon.html.DIV.append" class="py-name" href="#" onclick="return doclink('link-111', 'append', 'link-76');">append</a></tt><tt class="py-op">(</tt><tt id="link-112" class="py-name"><a title="web2py.gluon.html.TR" class="py-name" href="#" onclick="return doclink('link-112', 'TR', 'link-77');">TR</a></tt><tt class="py-op">(</tt><tt id="link-113" class="py-name"><a title="web2py.gluon.html.LABEL" class="py-name" href="#" onclick="return doclink('link-113', 'LABEL', 'link-75');">LABEL</a></tt><tt class="py-op">(</tt><tt class="py-name">delete_label</tt><tt class="py-op">,</tt> <tt class="py-name">_for</tt><tt class="py-op">=</tt><tt class="py-string">'delete_record'</tt><tt class="py-op">,</tt> </tt>
<a name="L413"></a><tt class="py-lineno">413</tt>  <tt class="py-line">                           <tt class="py-name">_id</tt><tt class="py-op">=</tt><tt class="py-string">'delete_record__label'</tt><tt class="py-op">)</tt><tt class="py-op">,</tt> </tt>
<a name="L414"></a><tt class="py-lineno">414</tt>  <tt class="py-line">                           <tt id="link-114" class="py-name"><a title="web2py.gluon.html.INPUT" class="py-name" href="#" onclick="return doclink('link-114', 'INPUT', 'link-9');">INPUT</a></tt><tt class="py-op">(</tt><tt class="py-name">_type</tt><tt class="py-op">=</tt><tt class="py-string">'checkbox'</tt><tt class="py-op">,</tt> <tt class="py-name">_class</tt><tt class="py-op">=</tt><tt class="py-string">'delete'</tt><tt class="py-op">,</tt> </tt>
<a name="L415"></a><tt class="py-lineno">415</tt>  <tt class="py-line">                           <tt class="py-name">_id</tt><tt class="py-op">=</tt><tt class="py-string">'delete_record'</tt><tt class="py-op">,</tt> </tt>
<a name="L416"></a><tt class="py-lineno">416</tt>  <tt class="py-line">                           <tt class="py-name">_name</tt><tt class="py-op">=</tt><tt class="py-string">'delete_this_record'</tt><tt class="py-op">)</tt><tt class="py-op">,</tt> </tt>
<a name="L417"></a><tt class="py-lineno">417</tt>  <tt class="py-line">                           <tt class="py-name">col3</tt><tt class="py-op">.</tt><tt class="py-name">get</tt><tt class="py-op">(</tt><tt class="py-string">'delete_record'</tt><tt class="py-op">,</tt> <tt class="py-string">''</tt><tt class="py-op">)</tt><tt class="py-op">,</tt> </tt>
<a name="L418"></a><tt class="py-lineno">418</tt>  <tt class="py-line">                           <tt class="py-name">_id</tt><tt class="py-op">=</tt><tt class="py-string">'delete_record__row'</tt><tt class="py-op">)</tt><tt class="py-op">)</tt> </tt>
<a name="L419"></a><tt class="py-lineno">419</tt>  <tt class="py-line">        <tt class="py-keyword">if</tt> <tt class="py-keyword">not</tt> <tt class="py-name">readonly</tt><tt class="py-op">:</tt> </tt>
<a name="L420"></a><tt class="py-lineno">420</tt>  <tt class="py-line">            <tt class="py-name">xfields</tt><tt class="py-op">.</tt><tt id="link-115" class="py-name"><a title="web2py.gluon.html.DIV.append" class="py-name" href="#" onclick="return doclink('link-115', 'append', 'link-76');">append</a></tt><tt class="py-op">(</tt><tt id="link-116" class="py-name"><a title="web2py.gluon.html.TR" class="py-name" href="#" onclick="return doclink('link-116', 'TR', 'link-77');">TR</a></tt><tt class="py-op">(</tt><tt class="py-string">''</tt><tt class="py-op">,</tt> <tt id="link-117" class="py-name"><a title="web2py.gluon.html.INPUT" class="py-name" href="#" onclick="return doclink('link-117', 'INPUT', 'link-9');">INPUT</a></tt><tt class="py-op">(</tt><tt class="py-name">_type</tt><tt class="py-op">=</tt><tt class="py-string">'submit'</tt><tt class="py-op">,</tt> </tt>
<a name="L421"></a><tt class="py-lineno">421</tt>  <tt class="py-line">                           <tt class="py-name">_value</tt><tt class="py-op">=</tt><tt class="py-name">submit_button</tt><tt class="py-op">)</tt><tt class="py-op">,</tt> </tt>
<a name="L422"></a><tt class="py-lineno">422</tt>  <tt class="py-line">                           <tt class="py-name">col3</tt><tt class="py-op">.</tt><tt class="py-name">get</tt><tt class="py-op">(</tt><tt class="py-string">'submit_button'</tt><tt class="py-op">,</tt> <tt class="py-string">''</tt><tt class="py-op">)</tt><tt class="py-op">,</tt> </tt>
<a name="L423"></a><tt class="py-lineno">423</tt>  <tt class="py-line">                           <tt class="py-name">_id</tt><tt class="py-op">=</tt><tt class="py-string">'submit_record__row'</tt><tt class="py-op">)</tt><tt class="py-op">)</tt> </tt>
<a name="L424"></a><tt class="py-lineno">424</tt>  <tt class="py-line">        <tt class="py-keyword">if</tt> <tt class="py-name">record</tt><tt class="py-op">:</tt> </tt>
<a name="L425"></a><tt class="py-lineno">425</tt>  <tt class="py-line">            <tt class="py-keyword">if</tt> <tt class="py-keyword">not</tt> <tt class="py-name">self</tt><tt class="py-op">[</tt><tt class="py-string">'hidden'</tt><tt class="py-op">]</tt><tt class="py-op">:</tt> </tt>
<a name="L426"></a><tt class="py-lineno">426</tt>  <tt class="py-line">                <tt class="py-name">self</tt><tt class="py-op">[</tt><tt class="py-string">'hidden'</tt><tt class="py-op">]</tt> <tt class="py-op">=</tt> <tt class="py-op">{</tt><tt class="py-op">}</tt> </tt>
<a name="L427"></a><tt class="py-lineno">427</tt>  <tt class="py-line">            <tt class="py-name">self</tt><tt class="py-op">[</tt><tt class="py-string">'hidden'</tt><tt class="py-op">]</tt><tt class="py-op">[</tt><tt class="py-string">'id'</tt><tt class="py-op">]</tt> <tt class="py-op">=</tt> <tt class="py-name">record</tt><tt class="py-op">[</tt><tt class="py-string">'id'</tt><tt class="py-op">]</tt> </tt>
<a name="L428"></a><tt class="py-lineno">428</tt>  <tt class="py-line">        <tt class="py-name">self</tt><tt class="py-op">.</tt><tt class="py-name">components</tt> <tt class="py-op">=</tt> <tt class="py-op">[</tt><tt id="link-118" class="py-name" targets="Class web2py.gluon.html.TABLE=web2py.gluon.html.TABLE-class.html"><a title="web2py.gluon.html.TABLE" class="py-name" href="#" onclick="return doclink('link-118', 'TABLE', 'link-118');">TABLE</a></tt><tt class="py-op">(</tt><tt class="py-op">*</tt><tt class="py-name">xfields</tt><tt class="py-op">)</tt><tt class="py-op">]</tt> </tt>
</div><a name="L429"></a><tt class="py-lineno">429</tt>  <tt class="py-line"> </tt>
<a name="SQLFORM.accepts"></a><div id="SQLFORM.accepts-def"><a name="L430"></a><tt class="py-lineno">430</tt> <a class="py-toggle" href="#" id="SQLFORM.accepts-toggle" onclick="return toggle('SQLFORM.accepts');">-</a><tt class="py-line">    <tt class="py-keyword">def</tt> <a class="py-def-name" href="web2py.gluon.sqlhtml.SQLFORM-class.html#accepts">accepts</a><tt class="py-op">(</tt> </tt>
<a name="L431"></a><tt class="py-lineno">431</tt>  <tt class="py-line">        <tt class="py-param">self</tt><tt class="py-op">,</tt> </tt>
<a name="L432"></a><tt class="py-lineno">432</tt>  <tt class="py-line">        <tt class="py-param">request_vars</tt><tt class="py-op">,</tt> </tt>
<a name="L433"></a><tt class="py-lineno">433</tt>  <tt class="py-line">        <tt class="py-param">session</tt><tt class="py-op">=</tt><tt class="py-name">None</tt><tt class="py-op">,</tt> </tt>
<a name="L434"></a><tt class="py-lineno">434</tt>  <tt class="py-line">        <tt class="py-param">formname</tt><tt class="py-op">=</tt><tt class="py-string">'%(tablename)s'</tt><tt class="py-op">,</tt> </tt>
<a name="L435"></a><tt class="py-lineno">435</tt>  <tt class="py-line">        <tt class="py-param">keepvalues</tt><tt class="py-op">=</tt><tt class="py-name">False</tt><tt class="py-op">,</tt> </tt>
<a name="L436"></a><tt class="py-lineno">436</tt>  <tt class="py-line">        <tt class="py-param">onvalidation</tt><tt class="py-op">=</tt><tt class="py-name">None</tt><tt class="py-op">,</tt> </tt>
<a name="L437"></a><tt class="py-lineno">437</tt>  <tt class="py-line">        <tt class="py-op">)</tt><tt class="py-op">:</tt> </tt>
</div><div id="SQLFORM.accepts-collapsed" style="display:none;" pad="+++" indent="++++++++"></div><div id="SQLFORM.accepts-expanded"><a name="L438"></a><tt class="py-lineno">438</tt>  <tt class="py-line">        <tt class="py-docstring">"""</tt> </tt>
<a name="L439"></a><tt class="py-lineno">439</tt>  <tt class="py-line"><tt class="py-docstring">        same as FORM.accepts but also does insert, update or delete in SQLDB.</tt> </tt>
<a name="L440"></a><tt class="py-lineno">440</tt>  <tt class="py-line"><tt class="py-docstring">        """</tt> </tt>
<a name="L441"></a><tt class="py-lineno">441</tt>  <tt class="py-line"> </tt>
<a name="L442"></a><tt class="py-lineno">442</tt>  <tt class="py-line">        <tt class="py-keyword">if</tt> <tt class="py-name">formname</tt><tt class="py-op">:</tt> </tt>
<a name="L443"></a><tt class="py-lineno">443</tt>  <tt class="py-line">            <tt class="py-name">formname</tt> <tt class="py-op">=</tt> <tt class="py-name">formname</tt> <tt class="py-op">%</tt> <tt class="py-name">dict</tt><tt class="py-op">(</tt><tt class="py-name">tablename</tt><tt class="py-op">=</tt><tt class="py-name">self</tt><tt class="py-op">.</tt><tt class="py-name">table</tt><tt class="py-op">.</tt><tt class="py-name">_tablename</tt><tt class="py-op">)</tt> </tt>
<a name="L444"></a><tt class="py-lineno">444</tt>  <tt class="py-line">        <tt class="py-keyword">if</tt> <tt class="py-name">self</tt><tt class="py-op">.</tt><tt class="py-name">record</tt><tt class="py-op">:</tt> </tt>
<a name="L445"></a><tt class="py-lineno">445</tt>  <tt class="py-line">            <tt class="py-name">record_id</tt> <tt class="py-op">=</tt> <tt class="py-name">request_vars</tt><tt class="py-op">.</tt><tt class="py-name">get</tt><tt class="py-op">(</tt><tt class="py-string">'id'</tt><tt class="py-op">,</tt> <tt class="py-name">None</tt><tt class="py-op">)</tt> </tt>
<a name="L446"></a><tt class="py-lineno">446</tt>  <tt class="py-line">        <tt class="py-keyword">else</tt><tt class="py-op">:</tt> </tt>
<a name="L447"></a><tt class="py-lineno">447</tt>  <tt class="py-line">            <tt class="py-name">record_id</tt> <tt class="py-op">=</tt> <tt class="py-name">None</tt> </tt>
<a name="L448"></a><tt class="py-lineno">448</tt>  <tt class="py-line">        <tt class="py-keyword">if</tt> <tt class="py-name">isinstance</tt><tt class="py-op">(</tt><tt class="py-name">record_id</tt><tt class="py-op">,</tt> <tt class="py-op">(</tt><tt class="py-name">list</tt><tt class="py-op">,</tt> <tt class="py-name">tuple</tt><tt class="py-op">)</tt><tt class="py-op">)</tt><tt class="py-op">:</tt> </tt>
<a name="L449"></a><tt class="py-lineno">449</tt>  <tt class="py-line">            <tt class="py-name">record_id</tt> <tt class="py-op">=</tt> <tt class="py-name">record_id</tt><tt class="py-op">[</tt><tt class="py-number">0</tt><tt class="py-op">]</tt> </tt>
<a name="L450"></a><tt class="py-lineno">450</tt>  <tt class="py-line"> </tt>
<a name="L451"></a><tt class="py-lineno">451</tt>  <tt class="py-line">        <tt class="py-comment"># ## THIS IS FOR UNIQUE RECORDS, read IS_NOT_IN_DB</tt> </tt>
<a name="L452"></a><tt class="py-lineno">452</tt>  <tt class="py-line"><tt class="py-comment"></tt> </tt>
<a name="L453"></a><tt class="py-lineno">453</tt>  <tt class="py-line">        <tt class="py-keyword">for</tt> <tt class="py-name">fieldname</tt> <tt class="py-keyword">in</tt> <tt class="py-name">self</tt><tt class="py-op">.</tt><tt class="py-name">fields</tt><tt class="py-op">:</tt> </tt>
<a name="L454"></a><tt class="py-lineno">454</tt>  <tt class="py-line">            <tt class="py-name">field</tt> <tt class="py-op">=</tt> <tt class="py-name">self</tt><tt class="py-op">.</tt><tt class="py-name">table</tt><tt class="py-op">[</tt><tt class="py-name">fieldname</tt><tt class="py-op">]</tt> </tt>
<a name="L455"></a><tt class="py-lineno">455</tt>  <tt class="py-line">            <tt class="py-name">requires</tt> <tt class="py-op">=</tt> <tt class="py-name">field</tt><tt class="py-op">.</tt><tt class="py-name">requires</tt> <tt class="py-keyword">or</tt> <tt class="py-op">[</tt><tt class="py-op">]</tt> </tt>
<a name="L456"></a><tt class="py-lineno">456</tt>  <tt class="py-line">            <tt class="py-keyword">if</tt> <tt class="py-keyword">not</tt> <tt class="py-name">isinstance</tt><tt class="py-op">(</tt><tt class="py-name">requires</tt><tt class="py-op">,</tt> <tt class="py-op">(</tt><tt class="py-name">list</tt><tt class="py-op">,</tt> <tt class="py-name">tuple</tt><tt class="py-op">)</tt><tt class="py-op">)</tt><tt class="py-op">:</tt> </tt>
<a name="L457"></a><tt class="py-lineno">457</tt>  <tt class="py-line">                <tt class="py-name">requires</tt> <tt class="py-op">=</tt> <tt class="py-op">[</tt><tt class="py-name">requires</tt><tt class="py-op">]</tt> </tt>
<a name="L458"></a><tt class="py-lineno">458</tt>  <tt class="py-line">            <tt class="py-op">[</tt><tt class="py-name">item</tt><tt class="py-op">.</tt><tt id="link-119" class="py-name" targets="Method web2py.gluon.validators.IS_NOT_IN_DB.set_self_id()=web2py.gluon.validators.IS_NOT_IN_DB-class.html#set_self_id,Method web2py.gluon.validators.IS_NULL_OR.set_self_id()=web2py.gluon.validators.IS_NULL_OR-class.html#set_self_id"><a title="web2py.gluon.validators.IS_NOT_IN_DB.set_self_id
web2py.gluon.validators.IS_NULL_OR.set_self_id" class="py-name" href="#" onclick="return doclink('link-119', 'set_self_id', 'link-119');">set_self_id</a></tt><tt class="py-op">(</tt><tt class="py-name">self</tt><tt class="py-op">.</tt><tt class="py-name">record_id</tt><tt class="py-op">)</tt> <tt class="py-keyword">for</tt> <tt class="py-name">item</tt> <tt class="py-keyword">in</tt> <tt class="py-name">requires</tt> </tt>
<a name="L459"></a><tt class="py-lineno">459</tt>  <tt class="py-line">            <tt class="py-keyword">if</tt> <tt class="py-name">hasattr</tt><tt class="py-op">(</tt><tt class="py-name">item</tt><tt class="py-op">,</tt> <tt class="py-string">'set_self_id'</tt><tt class="py-op">)</tt><tt class="py-op">]</tt> </tt>
<a name="L460"></a><tt class="py-lineno">460</tt>  <tt class="py-line"> </tt>
<a name="L461"></a><tt class="py-lineno">461</tt>  <tt class="py-line">        <tt class="py-comment"># ## END</tt> </tt>
<a name="L462"></a><tt class="py-lineno">462</tt>  <tt class="py-line"><tt class="py-comment"></tt> </tt>
<a name="L463"></a><tt class="py-lineno">463</tt>  <tt class="py-line">        <tt class="py-name">fields</tt> <tt class="py-op">=</tt> <tt class="py-op">{</tt><tt class="py-op">}</tt> </tt>
<a name="L464"></a><tt class="py-lineno">464</tt>  <tt class="py-line">        <tt class="py-keyword">for</tt> <tt class="py-name">key</tt> <tt class="py-keyword">in</tt> <tt class="py-name">self</tt><tt class="py-op">.</tt><tt class="py-name">vars</tt><tt class="py-op">.</tt><tt class="py-name">keys</tt><tt class="py-op">(</tt><tt class="py-op">)</tt><tt class="py-op">:</tt> </tt>
<a name="L465"></a><tt class="py-lineno">465</tt>  <tt class="py-line">            <tt class="py-name">fields</tt><tt class="py-op">[</tt><tt class="py-name">key</tt><tt class="py-op">]</tt> <tt class="py-op">=</tt> <tt class="py-name">self</tt><tt class="py-op">.</tt><tt class="py-name">vars</tt><tt class="py-op">[</tt><tt class="py-name">key</tt><tt class="py-op">]</tt> </tt>
<a name="L466"></a><tt class="py-lineno">466</tt>  <tt class="py-line">        <tt class="py-name">ret</tt> <tt class="py-op">=</tt> <tt id="link-120" class="py-name"><a title="web2py.gluon.html.FORM" class="py-name" href="#" onclick="return doclink('link-120', 'FORM', 'link-63');">FORM</a></tt><tt class="py-op">.</tt><tt id="link-121" class="py-name" targets="Method web2py.gluon.html.FORM.accepts()=web2py.gluon.html.FORM-class.html#accepts,Method web2py.gluon.sqlhtml.SQLFORM.accepts()=web2py.gluon.sqlhtml.SQLFORM-class.html#accepts"><a title="web2py.gluon.html.FORM.accepts
web2py.gluon.sqlhtml.SQLFORM.accepts" class="py-name" href="#" onclick="return doclink('link-121', 'accepts', 'link-121');">accepts</a></tt><tt class="py-op">(</tt> </tt>
<a name="L467"></a><tt class="py-lineno">467</tt>  <tt class="py-line">            <tt class="py-name">self</tt><tt class="py-op">,</tt> </tt>
<a name="L468"></a><tt class="py-lineno">468</tt>  <tt class="py-line">            <tt class="py-name">request_vars</tt><tt class="py-op">,</tt> </tt>
<a name="L469"></a><tt class="py-lineno">469</tt>  <tt class="py-line">            <tt class="py-name">session</tt><tt class="py-op">,</tt> </tt>
<a name="L470"></a><tt class="py-lineno">470</tt>  <tt class="py-line">            <tt class="py-name">formname</tt><tt class="py-op">,</tt> </tt>
<a name="L471"></a><tt class="py-lineno">471</tt>  <tt class="py-line">            <tt class="py-name">keepvalues</tt><tt class="py-op">,</tt> </tt>
<a name="L472"></a><tt class="py-lineno">472</tt>  <tt class="py-line">            <tt class="py-name">onvalidation</tt><tt class="py-op">,</tt> </tt>
<a name="L473"></a><tt class="py-lineno">473</tt>  <tt class="py-line">            <tt class="py-op">)</tt> </tt>
<a name="L474"></a><tt class="py-lineno">474</tt>  <tt class="py-line">        <tt class="py-name">auch</tt> <tt class="py-op">=</tt> <tt class="py-name">record_id</tt> <tt class="py-keyword">and</tt> \ </tt>
<a name="L475"></a><tt class="py-lineno">475</tt>  <tt class="py-line">               <tt class="py-name">self</tt><tt class="py-op">.</tt><tt class="py-name">errors</tt> <tt class="py-keyword">and</tt> \ </tt>
<a name="L476"></a><tt class="py-lineno">476</tt>  <tt class="py-line">               <tt class="py-name">request_vars</tt><tt class="py-op">.</tt><tt class="py-name">get</tt><tt class="py-op">(</tt><tt class="py-string">'delete_this_record'</tt><tt class="py-op">,</tt> <tt class="py-name">False</tt><tt class="py-op">)</tt> </tt>
<a name="L477"></a><tt class="py-lineno">477</tt>  <tt class="py-line">        <tt class="py-comment"># auch is true when user tries to delete a record</tt> </tt>
<a name="L478"></a><tt class="py-lineno">478</tt>  <tt class="py-line"><tt class="py-comment"></tt>        <tt class="py-comment"># that does not pass validation, yet it should be deleted </tt> </tt>
<a name="L479"></a><tt class="py-lineno">479</tt>  <tt class="py-line"><tt class="py-comment"></tt>        <tt class="py-keyword">if</tt> <tt class="py-keyword">not</tt> <tt class="py-name">ret</tt> <tt class="py-keyword">and</tt> <tt class="py-keyword">not</tt> <tt class="py-name">auch</tt><tt class="py-op">:</tt> </tt>
<a name="L480"></a><tt class="py-lineno">480</tt>  <tt class="py-line">            <tt class="py-keyword">for</tt> <tt class="py-name">fieldname</tt> <tt class="py-keyword">in</tt> <tt class="py-name">self</tt><tt class="py-op">.</tt><tt class="py-name">fields</tt><tt class="py-op">:</tt> </tt>
<a name="L481"></a><tt class="py-lineno">481</tt>  <tt class="py-line">                <tt class="py-name">field</tt> <tt class="py-op">=</tt> <tt class="py-name">self</tt><tt class="py-op">.</tt><tt class="py-name">table</tt><tt class="py-op">[</tt><tt class="py-name">fieldname</tt><tt class="py-op">]</tt> </tt>
<a name="L482"></a><tt class="py-lineno">482</tt>  <tt class="py-line">                <tt class="py-keyword">if</tt> <tt class="py-name">hasattr</tt><tt class="py-op">(</tt><tt class="py-name">field</tt><tt class="py-op">,</tt> <tt class="py-string">'widget'</tt><tt class="py-op">)</tt> <tt class="py-keyword">and</tt> <tt class="py-name">field</tt><tt class="py-op">.</tt><tt id="link-122" class="py-name"><a title="web2py.gluon.sqlhtml.BooleanWidget.widget
web2py.gluon.sqlhtml.MultipleOptionsWidget.widget
web2py.gluon.sqlhtml.OptionsWidget.widget
web2py.gluon.sqlhtml.PasswordWidget.widget
web2py.gluon.sqlhtml.StringWidget.widget
web2py.gluon.sqlhtml.TextWidget.widget
web2py.gluon.sqlhtml.UploadWidget.widget
web2py.gluon.widget" class="py-name" href="#" onclick="return doclink('link-122', 'widget', 'link-85');">widget</a></tt>\ </tt>
<a name="L483"></a><tt class="py-lineno">483</tt>  <tt class="py-line">                    <tt class="py-keyword">and</tt> <tt class="py-name">request_vars</tt><tt class="py-op">.</tt><tt class="py-name">has_key</tt><tt class="py-op">(</tt><tt class="py-name">fieldname</tt><tt class="py-op">)</tt><tt class="py-op">:</tt> </tt>
<a name="L484"></a><tt class="py-lineno">484</tt>  <tt class="py-line">                    <tt class="py-name">self</tt><tt class="py-op">.</tt><tt class="py-name">trows</tt><tt class="py-op">[</tt><tt class="py-name">fieldname</tt><tt class="py-op">]</tt><tt class="py-op">[</tt><tt class="py-number">1</tt><tt class="py-op">]</tt><tt class="py-op">[</tt><tt class="py-number">0</tt><tt class="py-op">]</tt><tt class="py-op">.</tt><tt class="py-name">components</tt> <tt class="py-op">=</tt> \ </tt>
<a name="L485"></a><tt class="py-lineno">485</tt>  <tt class="py-line">                        <tt class="py-op">[</tt><tt class="py-name">field</tt><tt class="py-op">.</tt><tt id="link-123" class="py-name"><a title="web2py.gluon.sqlhtml.BooleanWidget.widget
web2py.gluon.sqlhtml.MultipleOptionsWidget.widget
web2py.gluon.sqlhtml.OptionsWidget.widget
web2py.gluon.sqlhtml.PasswordWidget.widget
web2py.gluon.sqlhtml.StringWidget.widget
web2py.gluon.sqlhtml.TextWidget.widget
web2py.gluon.sqlhtml.UploadWidget.widget
web2py.gluon.widget" class="py-name" href="#" onclick="return doclink('link-123', 'widget', 'link-85');">widget</a></tt><tt class="py-op">(</tt><tt class="py-name">field</tt><tt class="py-op">,</tt> <tt class="py-name">request_vars</tt><tt class="py-op">[</tt><tt class="py-name">fieldname</tt><tt class="py-op">]</tt><tt class="py-op">)</tt><tt class="py-op">]</tt> </tt>
<a name="L486"></a><tt class="py-lineno">486</tt>  <tt class="py-line">            <tt class="py-keyword">return</tt> <tt class="py-name">ret</tt> </tt>
<a name="L487"></a><tt class="py-lineno">487</tt>  <tt class="py-line"> </tt>
<a name="L488"></a><tt class="py-lineno">488</tt>  <tt class="py-line">        <tt class="py-keyword">if</tt> <tt class="py-name">record_id</tt> <tt class="py-keyword">and</tt> <tt class="py-name">record_id</tt> <tt class="py-op">!=</tt> <tt class="py-name">self</tt><tt class="py-op">.</tt><tt class="py-name">record_id</tt><tt class="py-op">:</tt> </tt>
<a name="L489"></a><tt class="py-lineno">489</tt>  <tt class="py-line">            <tt class="py-keyword">raise</tt> <tt class="py-name">SyntaxError</tt><tt class="py-op">,</tt> <tt class="py-string">'user is tampering with form'</tt> </tt>
<a name="L490"></a><tt class="py-lineno">490</tt>  <tt class="py-line"> </tt>
<a name="L491"></a><tt class="py-lineno">491</tt>  <tt class="py-line">        <tt class="py-keyword">if</tt> <tt class="py-name">request_vars</tt><tt class="py-op">.</tt><tt class="py-name">get</tt><tt class="py-op">(</tt><tt class="py-string">'delete_this_record'</tt><tt class="py-op">,</tt> <tt class="py-name">False</tt><tt class="py-op">)</tt><tt class="py-op">:</tt> </tt>
<a name="L492"></a><tt class="py-lineno">492</tt>  <tt class="py-line">            <tt class="py-name">self</tt><tt class="py-op">.</tt><tt class="py-name">table</tt><tt class="py-op">.</tt><tt class="py-name">_db</tt><tt class="py-op">(</tt><tt class="py-name">self</tt><tt class="py-op">.</tt><tt class="py-name">table</tt><tt class="py-op">.</tt><tt class="py-name">id</tt> <tt class="py-op">==</tt> <tt class="py-name">self</tt><tt class="py-op">.</tt><tt class="py-name">record</tt><tt class="py-op">.</tt><tt class="py-name">id</tt><tt class="py-op">)</tt><tt class="py-op">.</tt><tt id="link-124" class="py-name" targets="Method web2py.gluon.sql.SQLSet.delete()=web2py.gluon.sql.SQLSet-class.html#delete,Method web2py.gluon.tools.Crud.delete()=web2py.gluon.tools.Crud-class.html#delete"><a title="web2py.gluon.sql.SQLSet.delete
web2py.gluon.tools.Crud.delete" class="py-name" href="#" onclick="return doclink('link-124', 'delete', 'link-124');">delete</a></tt><tt class="py-op">(</tt><tt class="py-op">)</tt> </tt>
<a name="L493"></a><tt class="py-lineno">493</tt>  <tt class="py-line">            <tt class="py-keyword">return</tt> <tt class="py-name">True</tt> </tt>
<a name="L494"></a><tt class="py-lineno">494</tt>  <tt class="py-line"> </tt>
<a name="L495"></a><tt class="py-lineno">495</tt>  <tt class="py-line">        <tt class="py-keyword">for</tt> <tt class="py-name">fieldname</tt> <tt class="py-keyword">in</tt> <tt class="py-name">self</tt><tt class="py-op">.</tt><tt class="py-name">fields</tt><tt class="py-op">:</tt> </tt>
<a name="L496"></a><tt class="py-lineno">496</tt>  <tt class="py-line">            <tt class="py-keyword">if</tt> <tt class="py-name">fieldname</tt> <tt class="py-op">==</tt> <tt class="py-string">'id'</tt><tt class="py-op">:</tt> </tt>
<a name="L497"></a><tt class="py-lineno">497</tt>  <tt class="py-line">                <tt class="py-keyword">continue</tt> </tt>
<a name="L498"></a><tt class="py-lineno">498</tt>  <tt class="py-line">            <tt class="py-keyword">if</tt> <tt class="py-keyword">not</tt> <tt class="py-name">self</tt><tt class="py-op">.</tt><tt class="py-name">table</tt><tt class="py-op">.</tt><tt class="py-name">has_key</tt><tt class="py-op">(</tt><tt class="py-name">fieldname</tt><tt class="py-op">)</tt><tt class="py-op">:</tt> </tt>
<a name="L499"></a><tt class="py-lineno">499</tt>  <tt class="py-line">                <tt class="py-keyword">continue</tt> </tt>
<a name="L500"></a><tt class="py-lineno">500</tt>  <tt class="py-line">            <tt class="py-keyword">if</tt> <tt class="py-keyword">not</tt> <tt class="py-name">self</tt><tt class="py-op">.</tt><tt class="py-name">table</tt><tt class="py-op">[</tt><tt class="py-name">fieldname</tt><tt class="py-op">]</tt><tt class="py-op">.</tt><tt class="py-name">writable</tt><tt class="py-op">:</tt> </tt>
<a name="L501"></a><tt class="py-lineno">501</tt>  <tt class="py-line">                <tt class="py-keyword">continue</tt> </tt>
<a name="L502"></a><tt class="py-lineno">502</tt>  <tt class="py-line">            <tt class="py-name">field</tt> <tt class="py-op">=</tt> <tt class="py-name">self</tt><tt class="py-op">.</tt><tt class="py-name">table</tt><tt class="py-op">[</tt><tt class="py-name">fieldname</tt><tt class="py-op">]</tt> </tt>
<a name="L503"></a><tt class="py-lineno">503</tt>  <tt class="py-line">            <tt class="py-keyword">if</tt> <tt class="py-name">field</tt><tt class="py-op">.</tt><tt class="py-name">type</tt> <tt class="py-op">==</tt> <tt class="py-string">'boolean'</tt><tt class="py-op">:</tt> </tt>
<a name="L504"></a><tt class="py-lineno">504</tt>  <tt class="py-line">                <tt class="py-keyword">if</tt> <tt class="py-name">self</tt><tt class="py-op">.</tt><tt class="py-name">vars</tt><tt class="py-op">.</tt><tt class="py-name">get</tt><tt class="py-op">(</tt><tt class="py-name">fieldname</tt><tt class="py-op">,</tt> <tt class="py-name">False</tt><tt class="py-op">)</tt><tt class="py-op">:</tt> </tt>
<a name="L505"></a><tt class="py-lineno">505</tt>  <tt class="py-line">                    <tt class="py-name">fields</tt><tt class="py-op">[</tt><tt class="py-name">fieldname</tt><tt class="py-op">]</tt> <tt class="py-op">=</tt> <tt class="py-name">True</tt> </tt>
<a name="L506"></a><tt class="py-lineno">506</tt>  <tt class="py-line">                <tt class="py-keyword">else</tt><tt class="py-op">:</tt> </tt>
<a name="L507"></a><tt class="py-lineno">507</tt>  <tt class="py-line">                    <tt class="py-name">fields</tt><tt class="py-op">[</tt><tt class="py-name">fieldname</tt><tt class="py-op">]</tt> <tt class="py-op">=</tt> <tt class="py-name">False</tt> </tt>
<a name="L508"></a><tt class="py-lineno">508</tt>  <tt class="py-line">            <tt class="py-keyword">elif</tt> <tt class="py-name">field</tt><tt class="py-op">.</tt><tt class="py-name">type</tt> <tt class="py-op">==</tt> <tt class="py-string">'password'</tt> <tt class="py-keyword">and</tt> <tt class="py-name">self</tt><tt class="py-op">.</tt><tt class="py-name">record</tt>\ </tt>
<a name="L509"></a><tt class="py-lineno">509</tt>  <tt class="py-line">                <tt class="py-keyword">and</tt> <tt class="py-name">request_vars</tt><tt class="py-op">.</tt><tt class="py-name">get</tt><tt class="py-op">(</tt><tt class="py-name">fieldname</tt><tt class="py-op">,</tt> <tt class="py-name">None</tt><tt class="py-op">)</tt> <tt class="py-op">==</tt> <tt class="py-string">'********'</tt><tt class="py-op">:</tt> </tt>
<a name="L510"></a><tt class="py-lineno">510</tt>  <tt class="py-line">                <tt class="py-keyword">continue</tt>  <tt class="py-comment"># do not update if password was not changed</tt> </tt>
<a name="L511"></a><tt class="py-lineno">511</tt>  <tt class="py-line">            <tt class="py-keyword">elif</tt> <tt class="py-name">field</tt><tt class="py-op">.</tt><tt class="py-name">type</tt> <tt class="py-op">==</tt> <tt class="py-string">'upload'</tt><tt class="py-op">:</tt> </tt>
<a name="L512"></a><tt class="py-lineno">512</tt>  <tt class="py-line">                <tt id="link-125" class="py-name"><a title="web2py.gluon.wsgiserver.SSLConnection.f" class="py-name" href="#" onclick="return doclink('link-125', 'f', 'link-65');">f</a></tt> <tt class="py-op">=</tt> <tt class="py-name">self</tt><tt class="py-op">.</tt><tt class="py-name">vars</tt><tt class="py-op">[</tt><tt class="py-name">fieldname</tt><tt class="py-op">]</tt> </tt>
<a name="L513"></a><tt class="py-lineno">513</tt>  <tt class="py-line">                <tt class="py-name">fd</tt> <tt class="py-op">=</tt> <tt class="py-name">fieldname</tt> <tt class="py-op">+</tt> <tt class="py-string">'__delete'</tt> </tt>
<a name="L514"></a><tt class="py-lineno">514</tt>  <tt class="py-line">                <tt class="py-keyword">if</tt> <tt class="py-keyword">not</tt> <tt class="py-name">isinstance</tt><tt class="py-op">(</tt><tt id="link-126" class="py-name"><a title="web2py.gluon.wsgiserver.SSLConnection.f" class="py-name" href="#" onclick="return doclink('link-126', 'f', 'link-65');">f</a></tt><tt class="py-op">,</tt> <tt class="py-op">(</tt><tt class="py-name">str</tt><tt class="py-op">,</tt> <tt class="py-name">unicode</tt><tt class="py-op">)</tt><tt class="py-op">)</tt><tt class="py-op">:</tt> </tt>
<a name="L515"></a><tt class="py-lineno">515</tt>  <tt class="py-line">                    <tt class="py-keyword">try</tt><tt class="py-op">:</tt> </tt>
<a name="L516"></a><tt class="py-lineno">516</tt>  <tt class="py-line">                        <tt class="py-name">e</tt> <tt class="py-op">=</tt> <tt id="link-127" class="py-name"><a title="web2py.gluon.sqlhtml.re_extension
web2py.gluon.tools.re_extension" class="py-name" href="#" onclick="return doclink('link-127', 're_extension', 'link-8');">re_extension</a></tt><tt class="py-op">.</tt><tt class="py-name">findall</tt><tt class="py-op">(</tt><tt id="link-128" class="py-name"><a title="web2py.gluon.wsgiserver.SSLConnection.f" class="py-name" href="#" onclick="return doclink('link-128', 'f', 'link-65');">f</a></tt><tt class="py-op">.</tt><tt class="py-name">filename</tt><tt class="py-op">.</tt><tt id="link-129" class="py-name" targets="Method web2py.gluon.sanitizer.XssCleaner.strip()=web2py.gluon.sanitizer.XssCleaner-class.html#strip"><a title="web2py.gluon.sanitizer.XssCleaner.strip" class="py-name" href="#" onclick="return doclink('link-129', 'strip', 'link-129');">strip</a></tt><tt class="py-op">(</tt><tt class="py-op">)</tt><tt class="py-op">)</tt><tt class="py-op">[</tt><tt class="py-number">0</tt><tt class="py-op">]</tt> </tt>
<a name="L517"></a><tt class="py-lineno">517</tt>  <tt class="py-line">                    <tt class="py-keyword">except</tt> <tt class="py-name">IndexError</tt><tt class="py-op">:</tt> </tt>
<a name="L518"></a><tt class="py-lineno">518</tt>  <tt class="py-line">                        <tt class="py-name">e</tt> <tt class="py-op">=</tt> <tt class="py-string">'.txt'</tt> </tt>
<a name="L519"></a><tt class="py-lineno">519</tt>  <tt class="py-line">                    <tt class="py-name">source_file</tt> <tt class="py-op">=</tt> <tt id="link-130" class="py-name"><a title="web2py.gluon.wsgiserver.SSLConnection.f" class="py-name" href="#" onclick="return doclink('link-130', 'f', 'link-65');">f</a></tt><tt class="py-op">.</tt><tt class="py-name">file</tt> </tt>
<a name="L520"></a><tt class="py-lineno">520</tt>  <tt class="py-line">                <tt class="py-keyword">else</tt><tt class="py-op">:</tt> </tt>
<a name="L521"></a><tt class="py-lineno">521</tt>  <tt class="py-line">                    <tt class="py-name">e</tt> <tt class="py-op">=</tt> <tt class="py-string">'.txt'</tt>  <tt class="py-comment"># ## DO NOT KNOW WHY THIS HAPPENS!</tt> </tt>
<a name="L522"></a><tt class="py-lineno">522</tt>  <tt class="py-line">                    <tt class="py-name">source_file</tt> <tt class="py-op">=</tt> <tt class="py-name">cStringIO</tt><tt class="py-op">.</tt><tt class="py-name">StringIO</tt><tt class="py-op">(</tt><tt id="link-131" class="py-name"><a title="web2py.gluon.wsgiserver.SSLConnection.f" class="py-name" href="#" onclick="return doclink('link-131', 'f', 'link-65');">f</a></tt><tt class="py-op">)</tt> </tt>
<a name="L523"></a><tt class="py-lineno">523</tt>  <tt class="py-line">                <tt class="py-keyword">if</tt> <tt id="link-132" class="py-name"><a title="web2py.gluon.wsgiserver.SSLConnection.f" class="py-name" href="#" onclick="return doclink('link-132', 'f', 'link-65');">f</a></tt> <tt class="py-op">!=</tt> <tt class="py-string">''</tt><tt class="py-op">:</tt> </tt>
<a name="L524"></a><tt class="py-lineno">524</tt>  <tt class="py-line">                    <tt class="py-name">newfilename</tt> <tt class="py-op">=</tt> <tt class="py-string">'%s.%s.%s%s'</tt>\ </tt>
<a name="L525"></a><tt class="py-lineno">525</tt>  <tt class="py-line">                        <tt class="py-op">%</tt> <tt class="py-op">(</tt><tt class="py-name">self</tt><tt class="py-op">.</tt><tt class="py-name">table</tt><tt class="py-op">.</tt><tt class="py-name">_tablename</tt><tt class="py-op">,</tt> <tt class="py-name">fieldname</tt><tt class="py-op">,</tt> </tt>
<a name="L526"></a><tt class="py-lineno">526</tt>  <tt class="py-line">                           <tt class="py-name">uuid</tt><tt class="py-op">.</tt><tt class="py-name">uuid4</tt><tt class="py-op">(</tt><tt class="py-op">)</tt><tt class="py-op">,</tt> <tt class="py-name">e</tt><tt class="py-op">)</tt> </tt>
<a name="L527"></a><tt class="py-lineno">527</tt>  <tt class="py-line">                    <tt class="py-name">self</tt><tt class="py-op">.</tt><tt class="py-name">vars</tt><tt class="py-op">[</tt><tt class="py-string">'%s_newfilename'</tt> <tt class="py-op">%</tt> <tt class="py-name">fieldname</tt><tt class="py-op">]</tt> <tt class="py-op">=</tt> <tt class="py-name">newfilename</tt> </tt>
<a name="L528"></a><tt class="py-lineno">528</tt>  <tt class="py-line">                    <tt class="py-name">fields</tt><tt class="py-op">[</tt><tt class="py-name">fieldname</tt><tt class="py-op">]</tt> <tt class="py-op">=</tt> <tt class="py-name">newfilename</tt> </tt>
<a name="L529"></a><tt class="py-lineno">529</tt>  <tt class="py-line">                    <tt class="py-keyword">if</tt> <tt class="py-name">field</tt><tt class="py-op">.</tt><tt class="py-name">uploadfield</tt> <tt class="py-op">==</tt> <tt class="py-name">True</tt><tt class="py-op">:</tt> </tt>
<a name="L530"></a><tt class="py-lineno">530</tt>  <tt class="py-line">                        <tt class="py-name">pathfilename</tt> <tt class="py-op">=</tt> \ </tt>
<a name="L531"></a><tt class="py-lineno">531</tt>  <tt class="py-line">                            <tt class="py-name">os</tt><tt class="py-op">.</tt><tt class="py-name">path</tt><tt class="py-op">.</tt><tt class="py-name">join</tt><tt class="py-op">(</tt><tt class="py-name">self</tt><tt class="py-op">.</tt><tt class="py-name">table</tt><tt class="py-op">.</tt><tt class="py-name">_db</tt><tt class="py-op">.</tt><tt class="py-name">_folder</tt><tt class="py-op">,</tt> </tt>
<a name="L532"></a><tt class="py-lineno">532</tt>  <tt class="py-line">                                <tt class="py-string">'../uploads/'</tt><tt class="py-op">,</tt> <tt class="py-name">newfilename</tt><tt class="py-op">)</tt> </tt>
<a name="L533"></a><tt class="py-lineno">533</tt>  <tt class="py-line">                        <tt class="py-name">dest_file</tt> <tt class="py-op">=</tt> <tt class="py-name">open</tt><tt class="py-op">(</tt><tt class="py-name">pathfilename</tt><tt class="py-op">,</tt> <tt class="py-string">'wb'</tt><tt class="py-op">)</tt> </tt>
<a name="L534"></a><tt class="py-lineno">534</tt>  <tt class="py-line">                        <tt class="py-name">shutil</tt><tt class="py-op">.</tt><tt class="py-name">copyfileobj</tt><tt class="py-op">(</tt><tt class="py-name">source_file</tt><tt class="py-op">,</tt> <tt class="py-name">dest_file</tt><tt class="py-op">)</tt> </tt>
<a name="L535"></a><tt class="py-lineno">535</tt>  <tt class="py-line">                        <tt class="py-name">dest_file</tt><tt class="py-op">.</tt><tt id="link-133" class="py-name" targets="Method web2py.gluon.wsgiserver.HTTPConnection.close()=web2py.gluon.wsgiserver.HTTPConnection-class.html#close,Method web2py.gluon.wsgiserver.SSLConnection.close()=web2py.gluon.wsgiserver.SSLConnection-class.html#close,Method web2py.gluon.wsgiserver.SSL_fileobject.close()=web2py.gluon.wsgiserver.SSL_fileobject-class.html#close,Method web2py.gluon.wsgiserver.SizeCheckWrapper.close()=web2py.gluon.wsgiserver.SizeCheckWrapper-class.html#close"><a title="web2py.gluon.wsgiserver.HTTPConnection.close
web2py.gluon.wsgiserver.SSLConnection.close
web2py.gluon.wsgiserver.SSL_fileobject.close
web2py.gluon.wsgiserver.SizeCheckWrapper.close" class="py-name" href="#" onclick="return doclink('link-133', 'close', 'link-133');">close</a></tt><tt class="py-op">(</tt><tt class="py-op">)</tt> </tt>
<a name="L536"></a><tt class="py-lineno">536</tt>  <tt class="py-line">                    <tt class="py-keyword">elif</tt> <tt class="py-name">field</tt><tt class="py-op">.</tt><tt class="py-name">uploadfield</tt><tt class="py-op">:</tt> </tt>
<a name="L537"></a><tt class="py-lineno">537</tt>  <tt class="py-line">                        <tt class="py-name">fields</tt><tt class="py-op">[</tt><tt class="py-name">field</tt><tt class="py-op">.</tt><tt class="py-name">uploadfield</tt><tt class="py-op">]</tt> <tt class="py-op">=</tt> <tt class="py-name">source_file</tt><tt class="py-op">.</tt><tt id="link-134" class="py-name" targets="Method web2py.gluon.tools.Crud.read()=web2py.gluon.tools.Crud-class.html#read,Method web2py.gluon.wsgiserver.SSLConnection.read()=web2py.gluon.wsgiserver.SSLConnection-class.html#read,Method web2py.gluon.wsgiserver.SSL_fileobject.read()=web2py.gluon.wsgiserver.SSL_fileobject-class.html#read,Method web2py.gluon.wsgiserver.SizeCheckWrapper.read()=web2py.gluon.wsgiserver.SizeCheckWrapper-class.html#read"><a title="web2py.gluon.tools.Crud.read
web2py.gluon.wsgiserver.SSLConnection.read
web2py.gluon.wsgiserver.SSL_fileobject.read
web2py.gluon.wsgiserver.SizeCheckWrapper.read" class="py-name" href="#" onclick="return doclink('link-134', 'read', 'link-134');">read</a></tt><tt class="py-op">(</tt><tt class="py-op">)</tt> </tt>
<a name="L538"></a><tt class="py-lineno">538</tt>  <tt class="py-line">                <tt class="py-keyword">elif</tt> <tt class="py-name">self</tt><tt class="py-op">.</tt><tt class="py-name">vars</tt><tt class="py-op">.</tt><tt class="py-name">get</tt><tt class="py-op">(</tt><tt class="py-name">fd</tt><tt class="py-op">,</tt> <tt class="py-name">False</tt><tt class="py-op">)</tt> <tt class="py-keyword">or</tt> <tt class="py-keyword">not</tt> <tt class="py-name">self</tt><tt class="py-op">.</tt><tt class="py-name">record</tt><tt class="py-op">:</tt> </tt>
<a name="L539"></a><tt class="py-lineno">539</tt>  <tt class="py-line">                    <tt class="py-name">fields</tt><tt class="py-op">[</tt><tt class="py-name">fieldname</tt><tt class="py-op">]</tt> <tt class="py-op">=</tt> <tt class="py-string">''</tt> </tt>
<a name="L540"></a><tt class="py-lineno">540</tt>  <tt class="py-line">                <tt class="py-keyword">else</tt><tt class="py-op">:</tt> </tt>
<a name="L541"></a><tt class="py-lineno">541</tt>  <tt class="py-line">                    <tt class="py-name">fields</tt><tt class="py-op">[</tt><tt class="py-name">fieldname</tt><tt class="py-op">]</tt> <tt class="py-op">=</tt> <tt class="py-name">self</tt><tt class="py-op">.</tt><tt class="py-name">record</tt><tt class="py-op">[</tt><tt class="py-name">fieldname</tt><tt class="py-op">]</tt> </tt>
<a name="L542"></a><tt class="py-lineno">542</tt>  <tt class="py-line">                <tt class="py-keyword">continue</tt> </tt>
<a name="L543"></a><tt class="py-lineno">543</tt>  <tt class="py-line">            <tt class="py-keyword">elif</tt> <tt class="py-name">self</tt><tt class="py-op">.</tt><tt class="py-name">vars</tt><tt class="py-op">.</tt><tt class="py-name">has_key</tt><tt class="py-op">(</tt><tt class="py-name">fieldname</tt><tt class="py-op">)</tt><tt class="py-op">:</tt> </tt>
<a name="L544"></a><tt class="py-lineno">544</tt>  <tt class="py-line">                <tt class="py-name">fields</tt><tt class="py-op">[</tt><tt class="py-name">fieldname</tt><tt class="py-op">]</tt> <tt class="py-op">=</tt> <tt class="py-name">self</tt><tt class="py-op">.</tt><tt class="py-name">vars</tt><tt class="py-op">[</tt><tt class="py-name">fieldname</tt><tt class="py-op">]</tt> </tt>
<a name="L545"></a><tt class="py-lineno">545</tt>  <tt class="py-line">            <tt class="py-keyword">elif</tt> <tt class="py-name">field</tt><tt class="py-op">.</tt><tt class="py-name">default</tt> <tt class="py-op">==</tt> <tt class="py-name">None</tt><tt class="py-op">:</tt> </tt>
<a name="L546"></a><tt class="py-lineno">546</tt>  <tt class="py-line">                <tt class="py-name">self</tt><tt class="py-op">.</tt><tt class="py-name">errors</tt><tt class="py-op">[</tt><tt class="py-name">fieldname</tt><tt class="py-op">]</tt> <tt class="py-op">=</tt> <tt class="py-string">'no data'</tt> </tt>
<a name="L547"></a><tt class="py-lineno">547</tt>  <tt class="py-line">                <tt class="py-keyword">return</tt> <tt class="py-name">False</tt> </tt>
<a name="L548"></a><tt class="py-lineno">548</tt>  <tt class="py-line">            <tt class="py-keyword">if</tt> <tt class="py-name">field</tt><tt class="py-op">.</tt><tt class="py-name">type</tt><tt class="py-op">[</tt><tt class="py-op">:</tt><tt class="py-number">9</tt><tt class="py-op">]</tt> <tt class="py-keyword">in</tt> <tt class="py-op">[</tt><tt class="py-string">'integer'</tt><tt class="py-op">,</tt> <tt class="py-string">'reference'</tt><tt class="py-op">]</tt><tt class="py-op">:</tt> </tt>
<a name="L549"></a><tt class="py-lineno">549</tt>  <tt class="py-line">                <tt class="py-keyword">if</tt> <tt class="py-name">fields</tt><tt class="py-op">[</tt><tt class="py-name">fieldname</tt><tt class="py-op">]</tt> <tt class="py-op">!=</tt> <tt class="py-name">None</tt><tt class="py-op">:</tt> </tt>
<a name="L550"></a><tt class="py-lineno">550</tt>  <tt class="py-line">                    <tt class="py-name">fields</tt><tt class="py-op">[</tt><tt class="py-name">fieldname</tt><tt class="py-op">]</tt> <tt class="py-op">=</tt> <tt class="py-name">int</tt><tt class="py-op">(</tt><tt class="py-name">fields</tt><tt class="py-op">[</tt><tt class="py-name">fieldname</tt><tt class="py-op">]</tt><tt class="py-op">)</tt> </tt>
<a name="L551"></a><tt class="py-lineno">551</tt>  <tt class="py-line">            <tt class="py-keyword">elif</tt> <tt class="py-name">field</tt><tt class="py-op">.</tt><tt class="py-name">type</tt> <tt class="py-op">==</tt> <tt class="py-string">'double'</tt><tt class="py-op">:</tt> </tt>
<a name="L552"></a><tt class="py-lineno">552</tt>  <tt class="py-line">                <tt class="py-keyword">if</tt> <tt class="py-name">fields</tt><tt class="py-op">[</tt><tt class="py-name">fieldname</tt><tt class="py-op">]</tt> <tt class="py-op">!=</tt> <tt class="py-name">None</tt><tt class="py-op">:</tt> </tt>
<a name="L553"></a><tt class="py-lineno">553</tt>  <tt class="py-line">                    <tt class="py-name">fields</tt><tt class="py-op">[</tt><tt class="py-name">fieldname</tt><tt class="py-op">]</tt> <tt class="py-op">=</tt> <tt class="py-name">float</tt><tt class="py-op">(</tt><tt class="py-name">fields</tt><tt class="py-op">[</tt><tt class="py-name">fieldname</tt><tt class="py-op">]</tt><tt class="py-op">)</tt> </tt>
<a name="L554"></a><tt class="py-lineno">554</tt>  <tt class="py-line">        <tt class="py-keyword">for</tt> <tt class="py-name">fieldname</tt> <tt class="py-keyword">in</tt> <tt class="py-name">self</tt><tt class="py-op">.</tt><tt class="py-name">vars</tt><tt class="py-op">:</tt> </tt>
<a name="L555"></a><tt class="py-lineno">555</tt>  <tt class="py-line">            <tt class="py-keyword">if</tt> <tt class="py-name">fieldname</tt> <tt class="py-op">!=</tt> <tt class="py-string">'id'</tt> <tt class="py-keyword">and</tt> <tt class="py-name">fieldname</tt> <tt class="py-keyword">in</tt> <tt class="py-name">self</tt><tt class="py-op">.</tt><tt class="py-name">table</tt><tt class="py-op">.</tt><tt class="py-name">fields</tt>\ </tt>
<a name="L556"></a><tt class="py-lineno">556</tt>  <tt class="py-line">                 <tt class="py-keyword">and</tt> <tt class="py-keyword">not</tt> <tt class="py-name">fieldname</tt> <tt class="py-keyword">in</tt> <tt class="py-name">fields</tt> <tt class="py-keyword">and</tt> <tt class="py-keyword">not</tt> <tt class="py-name">fieldname</tt>\ </tt>
<a name="L557"></a><tt class="py-lineno">557</tt>  <tt class="py-line">                 <tt class="py-keyword">in</tt> <tt class="py-name">request_vars</tt><tt class="py-op">:</tt> </tt>
<a name="L558"></a><tt class="py-lineno">558</tt>  <tt class="py-line">                <tt class="py-name">fields</tt><tt class="py-op">[</tt><tt class="py-name">fieldname</tt><tt class="py-op">]</tt> <tt class="py-op">=</tt> <tt class="py-name">self</tt><tt class="py-op">.</tt><tt class="py-name">vars</tt><tt class="py-op">[</tt><tt class="py-name">fieldname</tt><tt class="py-op">]</tt> </tt>
<a name="L559"></a><tt class="py-lineno">559</tt>  <tt class="py-line">        <tt class="py-keyword">if</tt> <tt class="py-name">record_id</tt><tt class="py-op">:</tt> </tt>
<a name="L560"></a><tt class="py-lineno">560</tt>  <tt class="py-line">            <tt class="py-name">self</tt><tt class="py-op">.</tt><tt class="py-name">vars</tt><tt class="py-op">.</tt><tt class="py-name">id</tt> <tt class="py-op">=</tt> <tt class="py-name">self</tt><tt class="py-op">.</tt><tt class="py-name">record</tt><tt class="py-op">.</tt><tt class="py-name">id</tt> </tt>
<a name="L561"></a><tt class="py-lineno">561</tt>  <tt class="py-line">            <tt class="py-keyword">if</tt> <tt class="py-name">fields</tt><tt class="py-op">:</tt> </tt>
<a name="L562"></a><tt class="py-lineno">562</tt>  <tt class="py-line">                <tt class="py-name">self</tt><tt class="py-op">.</tt><tt class="py-name">table</tt><tt class="py-op">.</tt><tt class="py-name">_db</tt><tt class="py-op">(</tt><tt class="py-name">self</tt><tt class="py-op">.</tt><tt class="py-name">table</tt><tt class="py-op">.</tt><tt class="py-name">id</tt><tt class="py-op">==</tt><tt class="py-name">self</tt><tt class="py-op">.</tt><tt class="py-name">record</tt><tt class="py-op">.</tt><tt class="py-name">id</tt><tt class="py-op">)</tt><tt class="py-op">.</tt><tt id="link-135" class="py-name" targets="Method web2py.gluon.html.DIV.update()=web2py.gluon.html.DIV-class.html#update,Method web2py.gluon.sql.SQLSet.update()=web2py.gluon.sql.SQLSet-class.html#update,Method web2py.gluon.tools.Crud.update()=web2py.gluon.tools.Crud-class.html#update,Method web2py.gluon.widget.web2pyDialog.update()=web2py.gluon.widget.web2pyDialog-class.html#update"><a title="web2py.gluon.html.DIV.update
web2py.gluon.sql.SQLSet.update
web2py.gluon.tools.Crud.update
web2py.gluon.widget.web2pyDialog.update" class="py-name" href="#" onclick="return doclink('link-135', 'update', 'link-135');">update</a></tt><tt class="py-op">(</tt><tt class="py-op">**</tt><tt class="py-name">fields</tt><tt class="py-op">)</tt> </tt>
<a name="L563"></a><tt class="py-lineno">563</tt>  <tt class="py-line">                <tt class="py-comment">### should really be </tt> </tt>
<a name="L564"></a><tt class="py-lineno">564</tt>  <tt class="py-line"><tt class="py-comment"></tt>                <tt class="py-comment"># self.table[record_id] = fields</tt> </tt>
<a name="L565"></a><tt class="py-lineno">565</tt>  <tt class="py-line"><tt class="py-comment"></tt>                <tt class="py-comment">### but on mysql update seems to return none</tt> </tt>
<a name="L566"></a><tt class="py-lineno">566</tt>  <tt class="py-line"><tt class="py-comment"></tt>        <tt class="py-keyword">else</tt><tt class="py-op">:</tt> </tt>
<a name="L567"></a><tt class="py-lineno">567</tt>  <tt class="py-line">            <tt class="py-name">self</tt><tt class="py-op">.</tt><tt class="py-name">vars</tt><tt class="py-op">.</tt><tt class="py-name">id</tt> <tt class="py-op">=</tt> <tt class="py-name">self</tt><tt class="py-op">.</tt><tt class="py-name">table</tt><tt class="py-op">.</tt><tt id="link-136" class="py-name"><a title="web2py.gluon.html.DIV.insert
web2py.gluon.sql.SQLTable.insert" class="py-name" href="#" onclick="return doclink('link-136', 'insert', 'link-69');">insert</a></tt><tt class="py-op">(</tt><tt class="py-op">**</tt><tt class="py-name">fields</tt><tt class="py-op">)</tt> </tt>
<a name="L568"></a><tt class="py-lineno">568</tt>  <tt class="py-line">        <tt class="py-keyword">return</tt> <tt class="py-name">ret</tt> </tt>
</div></div><a name="L569"></a><tt class="py-lineno">569</tt>  <tt class="py-line"> </tt>
<a name="SQLTABLE"></a><div id="SQLTABLE-def"><a name="L570"></a><tt class="py-lineno">570</tt>  <tt class="py-line"> </tt>
<a name="L571"></a><tt class="py-lineno">571</tt> <a class="py-toggle" href="#" id="SQLTABLE-toggle" onclick="return toggle('SQLTABLE');">-</a><tt class="py-line"><tt class="py-keyword">class</tt> <a class="py-def-name" href="web2py.gluon.sqlhtml.SQLTABLE-class.html">SQLTABLE</a><tt class="py-op">(</tt><tt class="py-base-class">TABLE</tt><tt class="py-op">)</tt><tt class="py-op">:</tt> </tt>
</div><div id="SQLTABLE-collapsed" style="display:none;" pad="+++" indent="++++"></div><div id="SQLTABLE-expanded"><a name="L572"></a><tt class="py-lineno">572</tt>  <tt class="py-line"> </tt>
<a name="L573"></a><tt class="py-lineno">573</tt>  <tt class="py-line">    <tt class="py-docstring">"""</tt> </tt>
<a name="L574"></a><tt class="py-lineno">574</tt>  <tt class="py-line"><tt class="py-docstring">    given a SQLRows object, as returned by a db().select(), generates</tt> </tt>
<a name="L575"></a><tt class="py-lineno">575</tt>  <tt class="py-line"><tt class="py-docstring">    an html table with the rows.</tt> </tt>
<a name="L576"></a><tt class="py-lineno">576</tt>  <tt class="py-line"><tt class="py-docstring"></tt> </tt>
<a name="L577"></a><tt class="py-lineno">577</tt>  <tt class="py-line"><tt class="py-docstring">    optional arguments:</tt> </tt>
<a name="L578"></a><tt class="py-lineno">578</tt>  <tt class="py-line"><tt class="py-docstring">    linkto: URL to edit individual records</tt> </tt>
<a name="L579"></a><tt class="py-lineno">579</tt>  <tt class="py-line"><tt class="py-docstring">    upload: URL to download uploaded files</tt> </tt>
<a name="L580"></a><tt class="py-lineno">580</tt>  <tt class="py-line"><tt class="py-docstring">    orderby: Add an orderby link to column headers.</tt> </tt>
<a name="L581"></a><tt class="py-lineno">581</tt>  <tt class="py-line"><tt class="py-docstring">    headers: dictionary of headers to headers redefinions</tt> </tt>
<a name="L582"></a><tt class="py-lineno">582</tt>  <tt class="py-line"><tt class="py-docstring">    truncate: length at which to truncate text in table cells.</tt> </tt>
<a name="L583"></a><tt class="py-lineno">583</tt>  <tt class="py-line"><tt class="py-docstring">              Defaults to 16 characters.</tt> </tt>
<a name="L584"></a><tt class="py-lineno">584</tt>  <tt class="py-line"><tt class="py-docstring">    optional names attributes for passed to the &lt;table&gt; tag</tt> </tt>
<a name="L585"></a><tt class="py-lineno">585</tt>  <tt class="py-line"><tt class="py-docstring">    """</tt> </tt>
<a name="L586"></a><tt class="py-lineno">586</tt>  <tt class="py-line"> </tt>
<a name="SQLTABLE.__init__"></a><div id="SQLTABLE.__init__-def"><a name="L587"></a><tt class="py-lineno">587</tt> <a class="py-toggle" href="#" id="SQLTABLE.__init__-toggle" onclick="return toggle('SQLTABLE.__init__');">-</a><tt class="py-line">    <tt class="py-keyword">def</tt> <a class="py-def-name" href="web2py.gluon.sqlhtml.SQLTABLE-class.html#__init__">__init__</a><tt class="py-op">(</tt> </tt>
<a name="L588"></a><tt class="py-lineno">588</tt>  <tt class="py-line">        <tt class="py-param">self</tt><tt class="py-op">,</tt> </tt>
<a name="L589"></a><tt class="py-lineno">589</tt>  <tt class="py-line">        <tt class="py-param">sqlrows</tt><tt class="py-op">,</tt> </tt>
<a name="L590"></a><tt class="py-lineno">590</tt>  <tt class="py-line">        <tt class="py-param">linkto</tt><tt class="py-op">=</tt><tt class="py-name">None</tt><tt class="py-op">,</tt> </tt>
<a name="L591"></a><tt class="py-lineno">591</tt>  <tt class="py-line">        <tt class="py-param">upload</tt><tt class="py-op">=</tt><tt class="py-name">None</tt><tt class="py-op">,</tt> </tt>
<a name="L592"></a><tt class="py-lineno">592</tt>  <tt class="py-line">        <tt class="py-param">orderby</tt><tt class="py-op">=</tt><tt class="py-name">None</tt><tt class="py-op">,</tt> </tt>
<a name="L593"></a><tt class="py-lineno">593</tt>  <tt class="py-line">        <tt class="py-param">headers</tt><tt class="py-op">=</tt><tt class="py-op">{</tt><tt class="py-op">}</tt><tt class="py-op">,</tt> </tt>
<a name="L594"></a><tt class="py-lineno">594</tt>  <tt class="py-line">        <tt class="py-param">truncate</tt><tt class="py-op">=</tt><tt class="py-number">16</tt><tt class="py-op">,</tt> </tt>
<a name="L595"></a><tt class="py-lineno">595</tt>  <tt class="py-line">        <tt class="py-op">**</tt><tt class="py-param">attributes</tt> </tt>
<a name="L596"></a><tt class="py-lineno">596</tt>  <tt class="py-line">        <tt class="py-op">)</tt><tt class="py-op">:</tt> </tt>
</div><div id="SQLTABLE.__init__-collapsed" style="display:none;" pad="+++" indent="++++++++"></div><div id="SQLTABLE.__init__-expanded"><a name="L597"></a><tt class="py-lineno">597</tt>  <tt class="py-line">        <tt id="link-137" class="py-name"><a title="web2py.gluon.html.TABLE" class="py-name" href="#" onclick="return doclink('link-137', 'TABLE', 'link-118');">TABLE</a></tt><tt class="py-op">.</tt><tt id="link-138" class="py-name"><a title="web2py.gluon.cache.Cache.__init__
web2py.gluon.cache.CacheInRam.__init__
web2py.gluon.cache.CacheOnDisk.__init__
web2py.gluon.globals.Request.__init__
web2py.gluon.globals.Response.__init__
web2py.gluon.highlight.Highlighter.__init__
web2py.gluon.html.BEAUTIFY.__init__
web2py.gluon.html.DIV.__init__
web2py.gluon.html.FORM.__init__
web2py.gluon.html.XML.__init__
web2py.gluon.http.HTTP.__init__
web2py.gluon.languages.lazyT.__init__
web2py.gluon.languages.translator.__init__
web2py.gluon.main.HttpServer.__init__
web2py.gluon.restricted.RestrictedError.__init__
web2py.gluon.sanitizer.XssCleaner.__init__
web2py.gluon.sql.SQLALL.__init__
web2py.gluon.sql.SQLDB.__init__
web2py.gluon.sql.SQLField.__init__
web2py.gluon.sql.SQLJoin.__init__
web2py.gluon.sql.SQLQuery.__init__
web2py.gluon.sql.SQLRows.__init__
web2py.gluon.sql.SQLSet.__init__
web2py.gluon.sql.SQLTable.__init__
web2py.gluon.sql.SQLXorable.__init__
web2py.gluon.sqlhtml.SQLFORM.__init__
web2py.gluon.sqlhtml.SQLTABLE.__init__
web2py.gluon.tools.Auth.__init__
web2py.gluon.tools.Crud.__init__
web2py.gluon.tools.Mail.__init__
web2py.gluon.tools.Recaptcha.__init__
web2py.gluon.tools.Service.__init__
web2py.gluon.validators.CLEANUP.__init__
web2py.gluon.validators.CRYPT.__init__
web2py.gluon.validators.IS_ALPHANUMERIC.__init__
web2py.gluon.validators.IS_DATE.__init__
web2py.gluon.validators.IS_DATETIME.__init__
web2py.gluon.validators.IS_EMAIL.__init__
web2py.gluon.validators.IS_EXPR.__init__
web2py.gluon.validators.IS_FLOAT_IN_RANGE.__init__
web2py.gluon.validators.IS_GENERIC_URL.__init__
web2py.gluon.validators.IS_HTTP_URL.__init__
web2py.gluon.validators.IS_INT_IN_RANGE.__init__
web2py.gluon.validators.IS_IN_DB.__init__
web2py.gluon.validators.IS_IN_SET.__init__
web2py.gluon.validators.IS_IN_SUBSET.__init__
web2py.gluon.validators.IS_LENGTH.__init__
web2py.gluon.validators.IS_LIST_OF.__init__
web2py.gluon.validators.IS_MATCH.__init__
web2py.gluon.validators.IS_NOT_EMPTY.__init__
web2py.gluon.validators.IS_NOT_IN_DB.__init__
web2py.gluon.validators.IS_NULL_OR.__init__
web2py.gluon.validators.IS_TIME.__init__
web2py.gluon.validators.IS_URL.__init__
web2py.gluon.widget.IO.__init__
web2py.gluon.widget.web2pyDialog.__init__
web2py.gluon.winservice.Service.__init__
web2py.gluon.wsgiserver.CherryPyWSGIServer.__init__
web2py.gluon.wsgiserver.HTTPConnection.__init__
web2py.gluon.wsgiserver.HTTPRequest.__init__
web2py.gluon.wsgiserver.SSLConnection.__init__
web2py.gluon.wsgiserver.SizeCheckWrapper.__init__
web2py.gluon.wsgiserver.ThreadPool.__init__
web2py.gluon.wsgiserver.WSGIPathInfoDispatcher.__init__
web2py.gluon.wsgiserver.WorkerThread.__init__" class="py-name" href="#" onclick="return doclink('link-138', '__init__', 'link-64');">__init__</a></tt><tt class="py-op">(</tt><tt class="py-name">self</tt><tt class="py-op">,</tt> <tt class="py-op">**</tt><tt class="py-name">attributes</tt><tt class="py-op">)</tt> </tt>
<a name="L598"></a><tt class="py-lineno">598</tt>  <tt class="py-line">        <tt class="py-name">self</tt><tt class="py-op">.</tt><tt class="py-name">components</tt> <tt class="py-op">=</tt> <tt class="py-op">[</tt><tt class="py-op">]</tt> </tt>
<a name="L599"></a><tt class="py-lineno">599</tt>  <tt class="py-line">        <tt class="py-name">self</tt><tt class="py-op">.</tt><tt class="py-name">attributes</tt> <tt class="py-op">=</tt> <tt class="py-name">attributes</tt> </tt>
<a name="L600"></a><tt class="py-lineno">600</tt>  <tt class="py-line">        <tt class="py-name">self</tt><tt class="py-op">.</tt><tt class="py-name">sqlrows</tt> <tt class="py-op">=</tt> <tt class="py-name">sqlrows</tt> </tt>
<a name="L601"></a><tt class="py-lineno">601</tt>  <tt class="py-line">        <tt class="py-op">(</tt><tt class="py-name">components</tt><tt class="py-op">,</tt> <tt class="py-name">row</tt><tt class="py-op">)</tt> <tt class="py-op">=</tt> <tt class="py-op">(</tt><tt class="py-name">self</tt><tt class="py-op">.</tt><tt class="py-name">components</tt><tt class="py-op">,</tt> <tt class="py-op">[</tt><tt class="py-op">]</tt><tt class="py-op">)</tt> </tt>
<a name="L602"></a><tt class="py-lineno">602</tt>  <tt class="py-line">        <tt class="py-keyword">if</tt> <tt class="py-keyword">not</tt> <tt class="py-name">orderby</tt><tt class="py-op">:</tt> </tt>
<a name="L603"></a><tt class="py-lineno">603</tt>  <tt class="py-line">            <tt class="py-keyword">for</tt> <tt class="py-name">c</tt> <tt class="py-keyword">in</tt> <tt class="py-name">sqlrows</tt><tt class="py-op">.</tt><tt class="py-name">colnames</tt><tt class="py-op">:</tt> </tt>
<a name="L604"></a><tt class="py-lineno">604</tt>  <tt class="py-line">                <tt class="py-name">row</tt><tt class="py-op">.</tt><tt id="link-139" class="py-name"><a title="web2py.gluon.html.DIV.append" class="py-name" href="#" onclick="return doclink('link-139', 'append', 'link-76');">append</a></tt><tt class="py-op">(</tt><tt id="link-140" class="py-name" targets="Class web2py.gluon.html.TH=web2py.gluon.html.TH-class.html"><a title="web2py.gluon.html.TH" class="py-name" href="#" onclick="return doclink('link-140', 'TH', 'link-140');">TH</a></tt><tt class="py-op">(</tt><tt class="py-name">headers</tt><tt class="py-op">.</tt><tt class="py-name">get</tt><tt class="py-op">(</tt><tt class="py-name">c</tt><tt class="py-op">,</tt> <tt class="py-name">c</tt><tt class="py-op">)</tt><tt class="py-op">)</tt><tt class="py-op">)</tt> </tt>
<a name="L605"></a><tt class="py-lineno">605</tt>  <tt class="py-line">        <tt class="py-keyword">else</tt><tt class="py-op">:</tt> </tt>
<a name="L606"></a><tt class="py-lineno">606</tt>  <tt class="py-line">            <tt class="py-keyword">for</tt> <tt class="py-name">c</tt> <tt class="py-keyword">in</tt> <tt class="py-name">sqlrows</tt><tt class="py-op">.</tt><tt class="py-name">colnames</tt><tt class="py-op">:</tt> </tt>
<a name="L607"></a><tt class="py-lineno">607</tt>  <tt class="py-line">                <tt class="py-name">row</tt><tt class="py-op">.</tt><tt id="link-141" class="py-name"><a title="web2py.gluon.html.DIV.append" class="py-name" href="#" onclick="return doclink('link-141', 'append', 'link-76');">append</a></tt><tt class="py-op">(</tt><tt id="link-142" class="py-name"><a title="web2py.gluon.html.TH" class="py-name" href="#" onclick="return doclink('link-142', 'TH', 'link-140');">TH</a></tt><tt class="py-op">(</tt><tt id="link-143" class="py-name"><a title="web2py.gluon.html.A" class="py-name" href="#" onclick="return doclink('link-143', 'A', 'link-39');">A</a></tt><tt class="py-op">(</tt><tt class="py-name">headers</tt><tt class="py-op">.</tt><tt class="py-name">get</tt><tt class="py-op">(</tt><tt class="py-name">c</tt><tt class="py-op">,</tt> <tt class="py-name">c</tt><tt class="py-op">)</tt><tt class="py-op">,</tt> <tt class="py-name">_href</tt><tt class="py-op">=</tt><tt class="py-string">'?orderby='</tt> </tt>
<a name="L608"></a><tt class="py-lineno">608</tt>  <tt class="py-line">                            <tt class="py-op">+</tt> <tt class="py-name">c</tt><tt class="py-op">)</tt><tt class="py-op">)</tt><tt class="py-op">)</tt> </tt>
<a name="L609"></a><tt class="py-lineno">609</tt>  <tt class="py-line">        <tt class="py-name">components</tt><tt class="py-op">.</tt><tt id="link-144" class="py-name"><a title="web2py.gluon.html.DIV.append" class="py-name" href="#" onclick="return doclink('link-144', 'append', 'link-76');">append</a></tt><tt class="py-op">(</tt><tt id="link-145" class="py-name" targets="Class web2py.gluon.html.THEAD=web2py.gluon.html.THEAD-class.html"><a title="web2py.gluon.html.THEAD" class="py-name" href="#" onclick="return doclink('link-145', 'THEAD', 'link-145');">THEAD</a></tt><tt class="py-op">(</tt><tt id="link-146" class="py-name"><a title="web2py.gluon.html.TR" class="py-name" href="#" onclick="return doclink('link-146', 'TR', 'link-77');">TR</a></tt><tt class="py-op">(</tt><tt class="py-op">*</tt><tt class="py-name">row</tt><tt class="py-op">)</tt><tt class="py-op">)</tt><tt class="py-op">)</tt> </tt>
<a name="L610"></a><tt class="py-lineno">610</tt>  <tt class="py-line">        <tt class="py-name">tbody</tt> <tt class="py-op">=</tt> <tt class="py-op">[</tt><tt class="py-op">]</tt> </tt>
<a name="L611"></a><tt class="py-lineno">611</tt>  <tt class="py-line">        <tt class="py-keyword">for</tt> <tt class="py-op">(</tt><tt class="py-name">rc</tt><tt class="py-op">,</tt> <tt class="py-name">record</tt><tt class="py-op">)</tt> <tt class="py-keyword">in</tt> <tt class="py-name">enumerate</tt><tt class="py-op">(</tt><tt class="py-name">sqlrows</tt><tt class="py-op">)</tt><tt class="py-op">:</tt> </tt>
<a name="L612"></a><tt class="py-lineno">612</tt>  <tt class="py-line">            <tt class="py-name">row</tt> <tt class="py-op">=</tt> <tt class="py-op">[</tt><tt class="py-op">]</tt> </tt>
<a name="L613"></a><tt class="py-lineno">613</tt>  <tt class="py-line">            <tt class="py-keyword">if</tt> <tt class="py-name">rc</tt> <tt class="py-op">%</tt> <tt class="py-number">2</tt> <tt class="py-op">==</tt> <tt class="py-number">0</tt><tt class="py-op">:</tt> </tt>
<a name="L614"></a><tt class="py-lineno">614</tt>  <tt class="py-line">                <tt class="py-name">_class</tt> <tt class="py-op">=</tt> <tt class="py-string">'even'</tt> </tt>
<a name="L615"></a><tt class="py-lineno">615</tt>  <tt class="py-line">            <tt class="py-keyword">else</tt><tt class="py-op">:</tt> </tt>
<a name="L616"></a><tt class="py-lineno">616</tt>  <tt class="py-line">                <tt class="py-name">_class</tt> <tt class="py-op">=</tt> <tt class="py-string">'odd'</tt> </tt>
<a name="L617"></a><tt class="py-lineno">617</tt>  <tt class="py-line">            <tt class="py-keyword">for</tt> <tt class="py-name">colname</tt> <tt class="py-keyword">in</tt> <tt class="py-name">sqlrows</tt><tt class="py-op">.</tt><tt class="py-name">colnames</tt><tt class="py-op">:</tt> </tt>
<a name="L618"></a><tt class="py-lineno">618</tt>  <tt class="py-line">                <tt class="py-keyword">if</tt> <tt class="py-keyword">not</tt> <tt id="link-147" class="py-name"><a title="web2py.gluon.sql.table_field
web2py.gluon.sqlhtml.table_field
web2py.gluon.tools.table_field" class="py-name" href="#" onclick="return doclink('link-147', 'table_field', 'link-7');">table_field</a></tt><tt class="py-op">.</tt><tt class="py-name">match</tt><tt class="py-op">(</tt><tt class="py-name">colname</tt><tt class="py-op">)</tt><tt class="py-op">:</tt> </tt>
<a name="L619"></a><tt class="py-lineno">619</tt>  <tt class="py-line">                    <tt class="py-name">r</tt> <tt class="py-op">=</tt> <tt class="py-name">record</tt><tt class="py-op">.</tt><tt class="py-name">_extra</tt><tt class="py-op">[</tt><tt class="py-name">colname</tt><tt class="py-op">]</tt> </tt>
<a name="L620"></a><tt class="py-lineno">620</tt>  <tt class="py-line">                    <tt class="py-name">row</tt><tt class="py-op">.</tt><tt id="link-148" class="py-name"><a title="web2py.gluon.html.DIV.append" class="py-name" href="#" onclick="return doclink('link-148', 'append', 'link-76');">append</a></tt><tt class="py-op">(</tt><tt id="link-149" class="py-name" targets="Class web2py.gluon.html.TD=web2py.gluon.html.TD-class.html"><a title="web2py.gluon.html.TD" class="py-name" href="#" onclick="return doclink('link-149', 'TD', 'link-149');">TD</a></tt><tt class="py-op">(</tt><tt class="py-name">r</tt><tt class="py-op">)</tt><tt class="py-op">)</tt> </tt>
<a name="L621"></a><tt class="py-lineno">621</tt>  <tt class="py-line">                    <tt class="py-keyword">continue</tt> </tt>
<a name="L622"></a><tt class="py-lineno">622</tt>  <tt class="py-line">                <tt class="py-op">(</tt><tt class="py-name">tablename</tt><tt class="py-op">,</tt> <tt class="py-name">fieldname</tt><tt class="py-op">)</tt> <tt class="py-op">=</tt> <tt class="py-name">colname</tt><tt class="py-op">.</tt><tt class="py-name">split</tt><tt class="py-op">(</tt><tt class="py-string">'.'</tt><tt class="py-op">)</tt> </tt>
<a name="L623"></a><tt class="py-lineno">623</tt>  <tt class="py-line">                <tt class="py-name">field</tt> <tt class="py-op">=</tt> <tt class="py-name">sqlrows</tt><tt class="py-op">.</tt><tt class="py-name">_db</tt><tt class="py-op">[</tt><tt class="py-name">tablename</tt><tt class="py-op">]</tt><tt class="py-op">[</tt><tt class="py-name">fieldname</tt><tt class="py-op">]</tt> </tt>
<a name="L624"></a><tt class="py-lineno">624</tt>  <tt class="py-line">                <tt class="py-keyword">if</tt> <tt class="py-name">record</tt><tt class="py-op">.</tt><tt class="py-name">has_key</tt><tt class="py-op">(</tt><tt class="py-name">tablename</tt><tt class="py-op">)</tt> <tt class="py-keyword">and</tt> <tt class="py-name">isinstance</tt><tt class="py-op">(</tt><tt class="py-name">record</tt><tt class="py-op">,</tt> </tt>
<a name="L625"></a><tt class="py-lineno">625</tt>  <tt class="py-line">                        <tt id="link-150" class="py-name"><a title="web2py.gluon.sql.SQLStorage" class="py-name" href="#" onclick="return doclink('link-150', 'SQLStorage', 'link-3');">SQLStorage</a></tt><tt class="py-op">)</tt> <tt class="py-keyword">and</tt> <tt class="py-name">isinstance</tt><tt class="py-op">(</tt><tt class="py-name">record</tt><tt class="py-op">[</tt><tt class="py-name">tablename</tt><tt class="py-op">]</tt><tt class="py-op">,</tt> </tt>
<a name="L626"></a><tt class="py-lineno">626</tt>  <tt class="py-line">                        <tt id="link-151" class="py-name"><a title="web2py.gluon.sql.SQLStorage" class="py-name" href="#" onclick="return doclink('link-151', 'SQLStorage', 'link-3');">SQLStorage</a></tt><tt class="py-op">)</tt><tt class="py-op">:</tt> </tt>
<a name="L627"></a><tt class="py-lineno">627</tt>  <tt class="py-line">                    <tt class="py-name">r</tt> <tt class="py-op">=</tt> <tt class="py-name">record</tt><tt class="py-op">[</tt><tt class="py-name">tablename</tt><tt class="py-op">]</tt><tt class="py-op">[</tt><tt class="py-name">fieldname</tt><tt class="py-op">]</tt> </tt>
<a name="L628"></a><tt class="py-lineno">628</tt>  <tt class="py-line">                <tt class="py-keyword">elif</tt> <tt class="py-name">record</tt><tt class="py-op">.</tt><tt class="py-name">has_key</tt><tt class="py-op">(</tt><tt class="py-name">fieldname</tt><tt class="py-op">)</tt><tt class="py-op">:</tt> </tt>
<a name="L629"></a><tt class="py-lineno">629</tt>  <tt class="py-line">                    <tt class="py-name">r</tt> <tt class="py-op">=</tt> <tt class="py-name">record</tt><tt class="py-op">[</tt><tt class="py-name">fieldname</tt><tt class="py-op">]</tt> </tt>
<a name="L630"></a><tt class="py-lineno">630</tt>  <tt class="py-line">                <tt class="py-keyword">else</tt><tt class="py-op">:</tt> </tt>
<a name="L631"></a><tt class="py-lineno">631</tt>  <tt class="py-line">                    <tt class="py-keyword">raise</tt> <tt class="py-name">SyntaxError</tt><tt class="py-op">,</tt> \ </tt>
<a name="L632"></a><tt class="py-lineno">632</tt>  <tt class="py-line">                        <tt class="py-string">'something wrong in SQLRows object'</tt> </tt>
<a name="L633"></a><tt class="py-lineno">633</tt>  <tt class="py-line">                <tt class="py-keyword">if</tt> <tt class="py-name">field</tt><tt class="py-op">.</tt><tt id="link-152" class="py-name"><a title="web2py.gluon.sqlhtml.UploadWidget.represent" class="py-name" href="#" onclick="return doclink('link-152', 'represent', 'link-80');">represent</a></tt><tt class="py-op">:</tt> </tt>
<a name="L634"></a><tt class="py-lineno">634</tt>  <tt class="py-line">                    <tt class="py-name">r</tt> <tt class="py-op">=</tt> <tt class="py-name">field</tt><tt class="py-op">.</tt><tt id="link-153" class="py-name"><a title="web2py.gluon.sqlhtml.UploadWidget.represent" class="py-name" href="#" onclick="return doclink('link-153', 'represent', 'link-80');">represent</a></tt><tt class="py-op">(</tt><tt class="py-name">r</tt><tt class="py-op">)</tt> </tt>
<a name="L635"></a><tt class="py-lineno">635</tt>  <tt class="py-line">                    <tt class="py-name">row</tt><tt class="py-op">.</tt><tt id="link-154" class="py-name"><a title="web2py.gluon.html.DIV.append" class="py-name" href="#" onclick="return doclink('link-154', 'append', 'link-76');">append</a></tt><tt class="py-op">(</tt><tt id="link-155" class="py-name"><a title="web2py.gluon.html.TD" class="py-name" href="#" onclick="return doclink('link-155', 'TD', 'link-149');">TD</a></tt><tt class="py-op">(</tt><tt class="py-name">r</tt><tt class="py-op">)</tt><tt class="py-op">)</tt> </tt>
<a name="L636"></a><tt class="py-lineno">636</tt>  <tt class="py-line">                    <tt class="py-keyword">continue</tt> </tt>
<a name="L637"></a><tt class="py-lineno">637</tt>  <tt class="py-line">                <tt class="py-keyword">if</tt> <tt class="py-name">field</tt><tt class="py-op">.</tt><tt class="py-name">type</tt> <tt class="py-op">==</tt> <tt class="py-string">'blob'</tt> <tt class="py-keyword">and</tt> <tt class="py-name">r</tt><tt class="py-op">:</tt> </tt>
<a name="L638"></a><tt class="py-lineno">638</tt>  <tt class="py-line">                    <tt class="py-name">row</tt><tt class="py-op">.</tt><tt id="link-156" class="py-name"><a title="web2py.gluon.html.DIV.append" class="py-name" href="#" onclick="return doclink('link-156', 'append', 'link-76');">append</a></tt><tt class="py-op">(</tt><tt id="link-157" class="py-name"><a title="web2py.gluon.html.TD" class="py-name" href="#" onclick="return doclink('link-157', 'TD', 'link-149');">TD</a></tt><tt class="py-op">(</tt><tt class="py-string">'DATA'</tt><tt class="py-op">)</tt><tt class="py-op">)</tt> </tt>
<a name="L639"></a><tt class="py-lineno">639</tt>  <tt class="py-line">                    <tt class="py-keyword">continue</tt> </tt>
<a name="L640"></a><tt class="py-lineno">640</tt>  <tt class="py-line">                <tt class="py-name">r</tt> <tt class="py-op">=</tt> <tt class="py-name">str</tt><tt class="py-op">(</tt><tt class="py-name">field</tt><tt class="py-op">.</tt><tt id="link-158" class="py-name"><a title="web2py.gluon.sql.SQLField.formatter
web2py.gluon.validators.IS_DATE.formatter
web2py.gluon.validators.IS_DATETIME.formatter
web2py.gluon.validators.IS_NULL_OR.formatter" class="py-name" href="#" onclick="return doclink('link-158', 'formatter', 'link-79');">formatter</a></tt><tt class="py-op">(</tt><tt class="py-name">r</tt><tt class="py-op">)</tt><tt class="py-op">)</tt> </tt>
<a name="L641"></a><tt class="py-lineno">641</tt>  <tt class="py-line">                <tt class="py-keyword">if</tt> <tt class="py-name">upload</tt> <tt class="py-keyword">and</tt> <tt class="py-name">field</tt><tt class="py-op">.</tt><tt class="py-name">type</tt> <tt class="py-op">==</tt> <tt class="py-string">'upload'</tt> <tt class="py-keyword">and</tt> <tt class="py-name">r</tt> <tt class="py-op">!=</tt> <tt class="py-name">None</tt><tt class="py-op">:</tt> </tt>
<a name="L642"></a><tt class="py-lineno">642</tt>  <tt class="py-line">                    <tt class="py-keyword">if</tt> <tt class="py-name">r</tt><tt class="py-op">:</tt> </tt>
<a name="L643"></a><tt class="py-lineno">643</tt>  <tt class="py-line">                        <tt class="py-name">row</tt><tt class="py-op">.</tt><tt id="link-159" class="py-name"><a title="web2py.gluon.html.DIV.append" class="py-name" href="#" onclick="return doclink('link-159', 'append', 'link-76');">append</a></tt><tt class="py-op">(</tt><tt id="link-160" class="py-name"><a title="web2py.gluon.html.TD" class="py-name" href="#" onclick="return doclink('link-160', 'TD', 'link-149');">TD</a></tt><tt class="py-op">(</tt><tt id="link-161" class="py-name"><a title="web2py.gluon.html.A" class="py-name" href="#" onclick="return doclink('link-161', 'A', 'link-39');">A</a></tt><tt class="py-op">(</tt><tt class="py-string">'file'</tt><tt class="py-op">,</tt> <tt class="py-name">_href</tt><tt class="py-op">=</tt><tt class="py-string">'%s/%s'</tt> </tt>
<a name="L644"></a><tt class="py-lineno">644</tt>  <tt class="py-line">                                    <tt class="py-op">%</tt> <tt class="py-op">(</tt><tt class="py-name">upload</tt><tt class="py-op">,</tt> <tt class="py-name">r</tt><tt class="py-op">)</tt><tt class="py-op">)</tt><tt class="py-op">)</tt><tt class="py-op">)</tt> </tt>
<a name="L645"></a><tt class="py-lineno">645</tt>  <tt class="py-line">                    <tt class="py-keyword">else</tt><tt class="py-op">:</tt> </tt>
<a name="L646"></a><tt class="py-lineno">646</tt>  <tt class="py-line">                        <tt class="py-name">row</tt><tt class="py-op">.</tt><tt id="link-162" class="py-name"><a title="web2py.gluon.html.DIV.append" class="py-name" href="#" onclick="return doclink('link-162', 'append', 'link-76');">append</a></tt><tt class="py-op">(</tt><tt id="link-163" class="py-name"><a title="web2py.gluon.html.TD" class="py-name" href="#" onclick="return doclink('link-163', 'TD', 'link-149');">TD</a></tt><tt class="py-op">(</tt><tt class="py-op">)</tt><tt class="py-op">)</tt> </tt>
<a name="L647"></a><tt class="py-lineno">647</tt>  <tt class="py-line">                    <tt class="py-keyword">continue</tt> </tt>
<a name="L648"></a><tt class="py-lineno">648</tt>  <tt class="py-line">                <tt class="py-name">ur</tt> <tt class="py-op">=</tt> <tt class="py-name">unicode</tt><tt class="py-op">(</tt><tt class="py-name">r</tt><tt class="py-op">,</tt> <tt class="py-string">'utf8'</tt><tt class="py-op">)</tt> </tt>
<a name="L649"></a><tt class="py-lineno">649</tt>  <tt class="py-line">                <tt class="py-keyword">if</tt> <tt class="py-name">len</tt><tt class="py-op">(</tt><tt class="py-name">ur</tt><tt class="py-op">)</tt> <tt class="py-op">&gt;</tt> <tt id="link-164" class="py-name" targets="Method web2py.gluon.sql.SQLTable.truncate()=web2py.gluon.sql.SQLTable-class.html#truncate"><a title="web2py.gluon.sql.SQLTable.truncate" class="py-name" href="#" onclick="return doclink('link-164', 'truncate', 'link-164');">truncate</a></tt><tt class="py-op">:</tt> </tt>
<a name="L650"></a><tt class="py-lineno">650</tt>  <tt class="py-line">                    <tt class="py-name">r</tt> <tt class="py-op">=</tt> <tt class="py-name">ur</tt><tt class="py-op">[</tt><tt class="py-op">:</tt><tt id="link-165" class="py-name"><a title="web2py.gluon.sql.SQLTable.truncate" class="py-name" href="#" onclick="return doclink('link-165', 'truncate', 'link-164');">truncate</a></tt> <tt class="py-op">-</tt> <tt class="py-number">3</tt><tt class="py-op">]</tt><tt class="py-op">.</tt><tt class="py-name">encode</tt><tt class="py-op">(</tt><tt class="py-string">'utf8'</tt><tt class="py-op">)</tt> <tt class="py-op">+</tt> <tt class="py-string">'...'</tt> </tt>
<a name="L651"></a><tt class="py-lineno">651</tt>  <tt class="py-line">                <tt class="py-keyword">if</tt> <tt class="py-name">linkto</tt> <tt class="py-keyword">and</tt> <tt class="py-name">field</tt><tt class="py-op">.</tt><tt class="py-name">type</tt> <tt class="py-op">==</tt> <tt class="py-string">'id'</tt><tt class="py-op">:</tt> </tt>
<a name="L652"></a><tt class="py-lineno">652</tt>  <tt class="py-line">                    <tt class="py-name">row</tt><tt class="py-op">.</tt><tt id="link-166" class="py-name"><a title="web2py.gluon.html.DIV.append" class="py-name" href="#" onclick="return doclink('link-166', 'append', 'link-76');">append</a></tt><tt class="py-op">(</tt><tt id="link-167" class="py-name"><a title="web2py.gluon.html.TD" class="py-name" href="#" onclick="return doclink('link-167', 'TD', 'link-149');">TD</a></tt><tt class="py-op">(</tt><tt id="link-168" class="py-name"><a title="web2py.gluon.html.A" class="py-name" href="#" onclick="return doclink('link-168', 'A', 'link-39');">A</a></tt><tt class="py-op">(</tt><tt class="py-name">r</tt><tt class="py-op">,</tt> <tt class="py-name">_href</tt><tt class="py-op">=</tt><tt class="py-string">'%s/%s/%s'</tt> <tt class="py-op">%</tt> <tt class="py-op">(</tt><tt class="py-name">linkto</tt><tt class="py-op">,</tt> </tt>
<a name="L653"></a><tt class="py-lineno">653</tt>  <tt class="py-line">                               <tt class="py-name">tablename</tt><tt class="py-op">,</tt> <tt class="py-name">r</tt><tt class="py-op">)</tt><tt class="py-op">)</tt><tt class="py-op">)</tt><tt class="py-op">)</tt> </tt>
<a name="L654"></a><tt class="py-lineno">654</tt>  <tt class="py-line">                <tt class="py-keyword">elif</tt> <tt class="py-name">linkto</tt> <tt class="py-keyword">and</tt> <tt class="py-name">field</tt><tt class="py-op">.</tt><tt class="py-name">type</tt><tt class="py-op">[</tt><tt class="py-op">:</tt><tt class="py-number">9</tt><tt class="py-op">]</tt> <tt class="py-op">==</tt> <tt class="py-string">'reference'</tt><tt class="py-op">:</tt> </tt>
<a name="L655"></a><tt class="py-lineno">655</tt>  <tt class="py-line">                    <tt class="py-name">row</tt><tt class="py-op">.</tt><tt id="link-169" class="py-name"><a title="web2py.gluon.html.DIV.append" class="py-name" href="#" onclick="return doclink('link-169', 'append', 'link-76');">append</a></tt><tt class="py-op">(</tt><tt id="link-170" class="py-name"><a title="web2py.gluon.html.TD" class="py-name" href="#" onclick="return doclink('link-170', 'TD', 'link-149');">TD</a></tt><tt class="py-op">(</tt><tt id="link-171" class="py-name"><a title="web2py.gluon.html.A" class="py-name" href="#" onclick="return doclink('link-171', 'A', 'link-39');">A</a></tt><tt class="py-op">(</tt><tt class="py-name">r</tt><tt class="py-op">,</tt> <tt class="py-name">_href</tt><tt class="py-op">=</tt><tt class="py-string">'%s/%s/%s'</tt> <tt class="py-op">%</tt> <tt class="py-op">(</tt><tt class="py-name">linkto</tt><tt class="py-op">,</tt> </tt>
<a name="L656"></a><tt class="py-lineno">656</tt>  <tt class="py-line">                               <tt class="py-name">field</tt><tt class="py-op">.</tt><tt class="py-name">type</tt><tt class="py-op">[</tt><tt class="py-number">10</tt><tt class="py-op">:</tt><tt class="py-op">]</tt><tt class="py-op">,</tt> <tt class="py-name">r</tt><tt class="py-op">)</tt><tt class="py-op">)</tt><tt class="py-op">)</tt><tt class="py-op">)</tt> </tt>
<a name="L657"></a><tt class="py-lineno">657</tt>  <tt class="py-line">                <tt class="py-keyword">else</tt><tt class="py-op">:</tt> </tt>
<a name="L658"></a><tt class="py-lineno">658</tt>  <tt class="py-line">                    <tt class="py-name">row</tt><tt class="py-op">.</tt><tt id="link-172" class="py-name"><a title="web2py.gluon.html.DIV.append" class="py-name" href="#" onclick="return doclink('link-172', 'append', 'link-76');">append</a></tt><tt class="py-op">(</tt><tt id="link-173" class="py-name"><a title="web2py.gluon.html.TD" class="py-name" href="#" onclick="return doclink('link-173', 'TD', 'link-149');">TD</a></tt><tt class="py-op">(</tt><tt class="py-name">r</tt><tt class="py-op">)</tt><tt class="py-op">)</tt> </tt>
<a name="L659"></a><tt class="py-lineno">659</tt>  <tt class="py-line">            <tt class="py-name">tbody</tt><tt class="py-op">.</tt><tt id="link-174" class="py-name"><a title="web2py.gluon.html.DIV.append" class="py-name" href="#" onclick="return doclink('link-174', 'append', 'link-76');">append</a></tt><tt class="py-op">(</tt><tt id="link-175" class="py-name"><a title="web2py.gluon.html.TR" class="py-name" href="#" onclick="return doclink('link-175', 'TR', 'link-77');">TR</a></tt><tt class="py-op">(</tt><tt class="py-name">_class</tt><tt class="py-op">=</tt><tt class="py-name">_class</tt><tt class="py-op">,</tt> <tt class="py-op">*</tt><tt class="py-name">row</tt><tt class="py-op">)</tt><tt class="py-op">)</tt> </tt>
<a name="L660"></a><tt class="py-lineno">660</tt>  <tt class="py-line">        <tt class="py-name">components</tt><tt class="py-op">.</tt><tt id="link-176" class="py-name"><a title="web2py.gluon.html.DIV.append" class="py-name" href="#" onclick="return doclink('link-176', 'append', 'link-76');">append</a></tt><tt class="py-op">(</tt><tt id="link-177" class="py-name" targets="Class web2py.gluon.html.TBODY=web2py.gluon.html.TBODY-class.html"><a title="web2py.gluon.html.TBODY" class="py-name" href="#" onclick="return doclink('link-177', 'TBODY', 'link-177');">TBODY</a></tt><tt class="py-op">(</tt><tt class="py-op">*</tt><tt class="py-name">tbody</tt><tt class="py-op">)</tt><tt class="py-op">)</tt> </tt>
</div></div><a name="L661"></a><tt class="py-lineno">661</tt>  <tt class="py-line"> </tt>
<a name="form_factory"></a><div id="form_factory-def"><a name="L662"></a><tt class="py-lineno">662</tt>  <tt class="py-line"> </tt>
<a name="L663"></a><tt class="py-lineno">663</tt> <a class="py-toggle" href="#" id="form_factory-toggle" onclick="return toggle('form_factory');">-</a><tt class="py-line"><tt class="py-keyword">def</tt> <a class="py-def-name" href="web2py.gluon.sqlhtml-module.html#form_factory">form_factory</a><tt class="py-op">(</tt><tt class="py-op">*</tt><tt class="py-param">fields</tt><tt class="py-op">,</tt> <tt class="py-op">**</tt><tt class="py-param">attributes</tt><tt class="py-op">)</tt><tt class="py-op">:</tt> </tt>
</div><div id="form_factory-collapsed" style="display:none;" pad="+++" indent="++++"></div><div id="form_factory-expanded"><a name="L664"></a><tt class="py-lineno">664</tt>  <tt class="py-line">    <tt class="py-keyword">return</tt> <tt id="link-178" class="py-name" targets="Class web2py.gluon.sqlhtml.SQLFORM=web2py.gluon.sqlhtml.SQLFORM-class.html"><a title="web2py.gluon.sqlhtml.SQLFORM" class="py-name" href="#" onclick="return doclink('link-178', 'SQLFORM', 'link-178');">SQLFORM</a></tt><tt class="py-op">(</tt><tt id="link-179" class="py-name"><a title="web2py.gluon.sql.SQLDB" class="py-name" href="#" onclick="return doclink('link-179', 'SQLDB', 'link-4');">SQLDB</a></tt><tt class="py-op">(</tt><tt class="py-name">None</tt><tt class="py-op">)</tt><tt class="py-op">.</tt><tt id="link-180" class="py-name" targets="Method web2py.gluon.sql.SQLDB.define_table()=web2py.gluon.sql.SQLDB-class.html#define_table"><a title="web2py.gluon.sql.SQLDB.define_table" class="py-name" href="#" onclick="return doclink('link-180', 'define_table', 'link-180');">define_table</a></tt><tt class="py-op">(</tt><tt class="py-string">'no_table'</tt><tt class="py-op">,</tt> <tt class="py-op">*</tt><tt class="py-name">fields</tt><tt class="py-op">)</tt><tt class="py-op">,</tt> </tt>
<a name="L665"></a><tt class="py-lineno">665</tt>  <tt class="py-line">                   <tt class="py-op">**</tt><tt class="py-name">attributes</tt><tt class="py-op">)</tt> </tt>
</div><a name="L666"></a><tt class="py-lineno">666</tt>  <tt class="py-line"> </tt><script type="text/javascript">
<!--
expandto(location.href);
// -->
</script>
</pre>
<br />
<!-- ==================== NAVIGATION BAR ==================== -->
<table class="navbar" border="0" width="100%" cellpadding="0"
       bgcolor="#a0c0ff" cellspacing="0">
  <tr valign="middle">
  <!-- Home link -->
      <th>&nbsp;&nbsp;&nbsp;<a
        href="web2py.gluon-module.html">Home</a>&nbsp;&nbsp;&nbsp;</th>

  <!-- Tree link -->
      <th>&nbsp;&nbsp;&nbsp;<a
        href="module-tree.html">Trees</a>&nbsp;&nbsp;&nbsp;</th>

  <!-- Index link -->
      <th>&nbsp;&nbsp;&nbsp;<a
        href="identifier-index.html">Indices</a>&nbsp;&nbsp;&nbsp;</th>

  <!-- Help link -->
      <th>&nbsp;&nbsp;&nbsp;<a
        href="help.html">Help</a>&nbsp;&nbsp;&nbsp;</th>

  <!-- Project homepage -->
      <th class="navbar" align="right" width="100%">
        <table border="0" cellpadding="0" cellspacing="0">
          <tr><th class="navbar" align="center"
            ><a class="navbar" target="_top" href="http://www.web2py.com">web2py Web Framework</a></th>
          </tr></table></th>
  </tr>
</table>
<table border="0" cellpadding="0" cellspacing="0" width="100%%">
  <tr>
    <td align="left" class="footer">
    Generated by Epydoc 3.0.1 on Wed Apr 15 13:10:26 2009
    </td>
    <td align="right" class="footer">
      <a target="mainFrame" href="http://epydoc.sourceforge.net"
        >http://epydoc.sourceforge.net</a>
    </td>
  </tr>
</table>

<script type="text/javascript">
  <!--
  // Private objects are initially displayed (because if
  // javascript is turned off then we want them to be
  // visible); but by default, we want to hide them.  So hide
  // them unless we have a cookie that says to show them.
  checkCookie();
  // -->
</script>
</body>
</html>
